Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is there BCP like utility for Oracle (to unload data to text file)
Sergei Didur wrote:
>
> I know that SQL Loader could load data from text file, but
> I'd like to unload data from Oracle DB to text file.
> Is it possible ???
Use SQL*Plus with pagesize of 0 and spool the output.
-- Nuno Souto nsouto_at_NOSPAMacay.com.auReceived on Wed Dec 03 1997 - 00:00:00 CST