Re: exporting a table to a flat file in .csv format
From: Frans H. <fransh_at_hotmail.com>
Date: 27 Aug 2003 00:07:29 -0700
Message-ID: <31abf0e5.0308262307.2284e968_at_posting.google.com>
Date: 27 Aug 2003 00:07:29 -0700
Message-ID: <31abf0e5.0308262307.2284e968_at_posting.google.com>
"Jon" <aaa_at_bbb.ccc> wrote in message news:<bift6e$i9c$1_at_unbe.sarenet.es>...
> I am trying to dump data from a table to a flat file in .csv format. I have
> read documentation for sqlplus utility but I have not seen any information
> about this apart from defining specific format for columns. Do you know if
> this is posible from sqplus?
>
> Thanks
Jon,
you could use a pl/sql procedure using the utl_file package.
Look at
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:235814350980
for a working example,
hth,
Frans H.
Received on Wed Aug 27 2003 - 09:07:29 CEST