Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting Data?
save this to a program :
set termout off
set heading off
set pagesize 0
set linesize <what you need>
<set the buffer size>
spool <file>
select <column> from <table>;
spo off;
exit
and run it from the command line sqlplus user/pass @your_prog.sql Received on Wed Nov 17 1999 - 09:26:50 CST