Re: export table data to comma delimited text file

Can you write a stored procedure which takes as argument a table name and an export filename, and exports the data of that table to the file?

Or, perhaps it takes some query criterion, and it exports the data returned by that query, to a text file?

In article <8hbq9g$4m$1_at_nnrp1.deja.com>,   Thomas J. Kyte <tkyte_at_us.oracle.com> wrote:
> In article <8h9am0$c08$1_at_nnrp1.deja.com>,
> orauser_at_my-deja.com wrote:
> > Whats the easiest way to export a table's data to a comma
> > delimited text file?
> >
> > Thanks :-)
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> see
> http://osi.oracle.com/~tkyte/flat/index.html
>
> --
> Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
> Howtos and such: http://osi.oracle.com/~tkyte/index.html
> Oracle Magazine: http://www.oracle.com/oramag
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 08 2000 - 00:00:00 CDT