Re: Oracle Server 7.3 table to .CSV file dump

From: Alistair Thomson <alistair.thomson_at_spinxcst.co.uk>
Date: 1998/04/29
Message-ID: <35470CD2.D23428F4@spinxcst.co.uk>#1/1

Do you have access to Discoverer 3 or the Browser tools? They let you save your output in any (well quite a few) format you choose.

Otherwise your looking at spooling output from sqlplus into a file and concatenating the fields together eg

select '"'||column1||'","'||column2||'"' from tablename;

The double quote is enclosed in single quotes, hope this helps.

Alistair Thomson

Tony Howard wrote:

> 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