Re: dump to CSV (comma-separated values) file format
- From: Aditya Alurkar <aalurkar@xxxxxxxxxxxx>
- To: ora-list <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Oct 2006 14:34:37 -0700
I have played with http://www.wisdomforce.com/FastReader and found it to be
useful as well
On 10/19/06 2:30 PM, "Mindaugas Navickas" <mnavickas@xxxxxxxxx> wrote:
> Note that if you take an approach sql*plus spool, it limits you to 4000
> characters. If you have tables that actual record length is longer, then
> PL/SQL code with dbms_sql/utl_file (code can be found on AskTom site) would be
> a better approch - even thought (from my experience) it's little slower.
>
> Mindaugas
> ----- Original Message ----
> From: Roger Xu <Roger.Xu@xxxxxxxxxxx>
> To: kevinc@xxxxxxxxxxxxx; Stefan Knecht <knecht.stefan@xxxxxxxxx>
> Cc: oracle-l <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, October 19, 2006 4:58:55 PM
> Subject: RE: dump to CSV (comma-separated values) file format
>
> thank you all - we are still in the traditional way (9i).
> SQL-generate-SQL is what I want now.
>
>
>
--
Adi Alurkar
aalurkar@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
