![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e293. Exporting an Oracle Table to a Flat FileThis example saves the output from aSELECT statement to a flat file
named outfile.txt .
To save to a file, turn on the spooler by typing
' SQL> spool outfile.txt SQL> select * from oracle_2_table; SQL> spool offYou can also create a SQL script to turn on and off the spooler and format the output the way you want: SQL> get_data.sqlThe contents of get_data.sql are:
set term off; // Suppress the display so that you can spool output without seeing the output on the screen. set heading off; // Turn off heading set linesize 400; // Set the number of characters per line to 400. Adjust this number to 0 or something for your real data. set feedback off; // Turn off feedback spool outfile.txt; // Spool the output to a file named outfile.txt select col1 ||','|| col2 from oracle_2_table; // Select each column from table oracle_2_table, delimiting by a comma spool off;
e294. Loading a Flat File to an Oracle Table e295. Exporting a MySQL Table to a Flat File © 2002 Addison-Wesley. |