set echo off
set verify off
set feedback off
set pagesize 0
set heading off
spool filename.CSV
select '"'||column1||'"'||','||'"'||column2||'"'||...
from tablename
where blahblahblah...
and yaddayaddayadda...
/
spool off
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
Tony Howard <tonyh_at_gmap.leeds.ac.uk> wrote in article
<3546F1BC.E143C216_at_gmap.leeds.ac.uk>...
> I need to dump oracle tables to proper comma delimited format files with
> strings in quotes, i.e. the same format you can use in sqlldr & most
> wordprocessors.
> Any clues much appreciated.
Received on Wed Apr 29 1998 - 00:00:00 CDT
