Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader

Re: SQL*Loader

From: <andy_at_movista.com>
Date: 16 Feb 2001 09:29:44 GMT
Message-ID: <96iru8$f93$1@news.netmar.com>

Try this

spool fred
select col1,..col2 from table;
spool off

use column and set commands to format output

HTH Andy
In article <96hv12$6ab1_at_imsp212.netvigator.com>, CSC <jcheong_at_cooper.com.hk> writes:
>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 - 03:29:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US