Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting Data?

Re: Exporting Data?

From: Screamer <mflopes_at_bigfoot.com>
Date: Wed, 17 Nov 1999 15:26:50 -0000
Message-ID: <80uhmc$a5o$1@duke.telepac.pt>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US