Prev: Dynamic PL/SQL - Get values from one cursor from another or alternatives?
Next: Dynamic PL/SQL - Get values from one cursor from another or alternatives?
From: sybrandb on 11 Aug 2008 09:54
On Mon, 11 Aug 2008 03:06:29 -0700 (PDT), bpfh <numerista(a)gmail.com>
wrote:

>
>I am fighting with PL/SQL and loosing...
>
>I have a database that changes on a regular basis and has over 200
>columns... and the data needs to be exported to a file.

You can use exp for this purpose.

If you want to dump it to ASCII or CSV, get the SQL Unloader (or
Dump2CSV) utility available on http://asktom.oracle.com

Will take any SQL statement as parameter, chew it, and sput out the
requested data

--
Sybrand Bakker
Senior Oracle DBA
 | 
Pages: 1
Prev: Dynamic PL/SQL - Get values from one cursor from another or alternatives?
Next: Dynamic PL/SQL - Get values from one cursor from another or alternatives?