Re: Dynamic PL/SQL - Get values from one cursor from another or alternatives?
Date: Mon, 11 Aug 2008 15:54:55 +0200
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 DBAReceived on Mon Aug 11 2008 - 08:54:55 CDT