Re: dump to CSV (comma-separated values) file format

From: Aditya Alurkar <aalurkar_at_linkedin.com>
Date: Thu, 19 Oct 2006 14:34:37 -0700
Message-ID: <C15D3D7D.4B73%aalurkar@linkedin.com>

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_at_yahoo.com> 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_at_dp7upbg.com>
> To: kevinc_at_polyserve.com; Stefan Knecht <knecht.stefan_at_gmail.com>
> Cc: oracle-l <oracle-l_at_freelists.org>
> 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_at_linkedin.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 19 2006 - 16:34:37 CDT