Re: Exporting Data

From: <edwardmi1_at_my-deja.com>
Date: Wed, 25 Oct 2000 11:20:25 GMT
Message-ID: <8t6fll$1ti$1@nnrp1.deja.com>

> Is there a simple way to export data from Oracle to an ascii text
file?

If you do not want/are not able to use third-party utilities like sqlunloader you can follow the next way (I've already followed): Execute select in the SQLPlus session and spool its result into file - it's manual method.
Use UTL_FILE and DBMS_SQL (you can see one of examples at http://govt.oracle.com/~tkyte/Misc/csv.html) - it's automatic method.

>
> Thanks
>
> Jim in Chicago
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 06:20:25 CDT