Re: novice: extract comma delimited data

From: dave <cowden_at_earthlink.net>
Date: Mon, 26 Apr 1999 23:39:40 -0400
Message-ID: <7g3bnd$k8q$1@holly.prod.itd.earthlink.net>

Try something like this, if the table is small enough, from sqlplus: set head off
set echo off
set pages 0
spool file.out
select field1 || ',' || field2 || ',' || field3 ... || ',' || fieldn from tablename
where <whatever>
spool off

If your table is really big this might take a while. Hope that helps.
Dave

Furkan Khan wrote in message <3724F703.B40C1E9B_at_home.com>...
>Folks, I am a novice at SQL, its been quite some time since I used
>it. Can someone recommend me the best way to dump out data
>from an oracle table into comma delimited form.
>
>I know the the Oracle Navigator allows it via the gui, but I want
>a sql script or some other scripting utility.
>
>Thanks in advance. You can mail me directly also.
>
>Regards.
>Furkan Khan
>
Received on Mon Apr 26 1999 - 22:39:40 CDT