Re: Comma separated file

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Tue, 16 Jul 2002 08:23:08 GMT
Message-ID: <ah0l7m$egi$1@news1.xs4all.nl>

Murty,

You could try our general data unloader, named SQL*Out. Free trial version available (win32 platforms). Command-line only.

Drop me an email, if you're interesed.

Kind Regards,

Herman de Boer
sr. consultant
IT Consultancy Group bv.

Murty Adavi wrote:

>Given a table, is there any way of extracting the data and create a
>Comma-separated ASCII text file ?
>I tried using the following .....
>
>SQLPLUS > SPOOL TEST.DAT
> > set pagesize 0
> > select COLA || ',' || COLB || ',' || COLC from
>TEST_TAB
>
>....but I am sure there should be a better way of doing this as this method
>doesn't properly get
>some of the datatypes like DATE, CLOB, etc.
>
>Thanks
>Murty
>
>
>
>
Received on Tue Jul 16 2002 - 03:23:08 CDT