Re: How to unload data from a table

banglea_at_onr.com wrote:

Something similar although not quite as friendly can be achieved with the SPOOL command. I've always harrassed Oracle for a 'conditional' export facility, but no luck to date (Maybe 8.0 !).

I have used spool and subsequent selects to create CSV files for PC packages where ODBC is not an option.

Spool <filename>
select column1 ||','|| column2 ||','|| column3 etc

	from object
	where condition

>Oracle does not provide a tool that will directly unload a table
>to a flat file. If your requirement only involves moving data
>from one Oracle DB to another, then you can utilize EXP/IMP to
 

>If your requirement involves non-Oracle databases, then you would
>likely need to roll your own using Pro*C or the OCI interfaces.
 

>>With Informix you can say:
>>unload to "filename" select ...
Received on Wed Mar 06 1996 - 00:00:00 CET