Re: SQL*Loader

Following is an example of creating
a comma delimied text file for
data from emp table consissting of
two fields : empno and emplname

spool emp.txt
set heading off etc.

select empno||','||emplname from emp ;
spool oof

Of course, utl_fil package is much more
powerful if one wants to do a little
PL/SQL programming to create the text file.

Regrads
Willy Received on Thu Feb 15 2001 - 22:17:26 CST