Oracle-L: RE: Query results to .csv

From: Guido Konsolke <Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com>
Date: Mon, 25 Aug 2003 05:14:32 -0800
Message-ID: <F001.005CD03B.20030825051432@fatcity.com>

Hi,

do some reading in the SQL*PLUS manual.
Read about:
- SET command (many useful options, e. g. LINESIZE, HEADING, COLSEP) - SPOOL command (spools the result)

hth and greetings,
Guido

>>> imran9a_at_hotmail.com 25.08.2003 14.39 Uhr >>>
Hi,

Whats the best way to write the results of a SQL query to a CSV file?

Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guido Konsolke
  INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Aug 25 2003 - 08:14:32 CDT