Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader
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
![]() |
![]() |