Re: Dynamic PL/SQL - Get values from one cursor from another or alternatives?

On Mon, 11 Aug 2008 03:06:29 -0700 (PDT), bpfh <numerista_at_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