Re: Data OUT from sqlldr

Unfortunately, the way to "dump out" a text file of table data is to use SQL*Plus. Create a SQL file with the commands:

set pagesize 0;
set feedback off;
set heading off;
set termout off;
set echo off;
set verify off;
spool <your_output_file_name>;
<your SQL>

spool off;
exit;

Then, execute the saved SQL file by typing "@<your_SQL_file_name>.SQL at the SQL prompt.

Cliff Received on Sun Apr 04 1999 - 09:20:01 CDT