ORCLE输出文本荟萃（国外英文资料）.doc

ORCLE输出文本荟萃（国外英文资料） DESCRIPTION: User = username/password @ora_sid CMD = select statement, eg: select * from TAB SQL = SQL file name The head = print column header (Yes | No) Record = seperator string between every rows Field = seperator string between fields Output = output file name (default output file: unload. TXT) (2) C: \ unload.exe user = jajf / * * @jadb8 CMD = select county_code, phone_id from zk. cm_user @crm_clone where county_code = 9657 field = 0x09 record = 0x0a output = 9657. TXT Export the area county and number fields in jizhou district, the fields are separated by newline characters, each record line is changed, and the exported data is 9657. TXT, under the current file directory. Rows unloaded at 2010-07-1817:09:26 272136 rows unloaded at 2010-07-18 17:10:54 Unloaded to output file 9657. TXT 272136 rows. (3) Through custom SQL file export data, SQL file called c.s. ql, file content for the select * from cj_county, has exported data TAB are separated, the exported data file defaults to unload. TXT, export data in the current directory. C: \ exe Rows unloaded at 2010-07-18 17:22:53 Rows unloaded at 2010-07-18 17:22:53 Unloaded to output file unloaded. TXT 14 rows. (4) Combined with the batch command, can save the input command of trival, save the following contents for unload. Bat, on disk c, open the CMD command line, under the command line input unload. Bat, relevant parameters can be derived according to clew input text file. @ echo off CLS Color 0 a The title ORACLE database table quickly exports the text tool CD \ Echo -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- : dis_run The Rem database exports text files Set the user = Set/p user = please enter the database user name password (format: username/password @dbname:) : If % u