Re: SQL*Loader

From: Ispirer <ispirer_at_ispirer.com>
Date: Fri, 16 Feb 2001 15:55:52 +0200
Message-ID: <96jbhh$l1u38$1@ID-75577.news.dfncis.de>

Hi, use tool at www.ispirer.com
It can generate CSV, TAB delimited and fixed length text files. Moreover it generates CREATE TABLE script and control file for SQLLoader.

select col1, col2 from t1
 or
select empno||','||emplname from emp ;

don't work because data can contain commas and double quotes.

Dmitry.

---

"CSC" <jcheong_at_cooper.com.hk> wrote in message news:96hv12$6ab1_at_imsp212.netvigator.com...
> I can use SQL*Loader to upload text file to database table but what should
> I use to extract data from a table or view to a text file?
>
>
> --
> e-Consultant
> http://www.asl.com.hk/employment.htm
> http://www.eroom.com
Received on Fri Feb 16 2001 - 07:55:52 CST