Note that if you take an approach sql*plus spool, it limits you to 4000 characters. If you have tables that actual record length is longer, then PL/SQL code with dbms_sql/utl_file (code can be found on AskTom site) would be a better approch - even thought (from my experience) it's little slower.
Mindaugas
----- Original Message ----
From: Roger Xu <Roger.Xu_at_dp7upbg.com>
To: kevinc_at_polyserve.com; Stefan Knecht <knecht.stefan_at_gmail.com>
Cc: oracle-l <oracle-l_at_freelists.org>
Sent: Thursday, October 19, 2006 4:58:55 PM
Subject: RE: dump to CSV (comma-separated values) file format
thank you all - we are still in the traditional way (9i).
SQL-generate-SQL is what I want now.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 19 2006 - 16:30:49 CDT
