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

From: <>
Date: Mon, 11 Aug 2008 15:54:55 +0200
Message-ID: <>

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

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

Sybrand Bakker
Senior Oracle DBA
Received on Mon Aug 11 2008 - 08:54:55 CDT

Original text of this message