Re: using sqlldr to extract the content of table to a file

Wilfrid wrote:
> Thanks all for your help.
> I tried this:
> from dos:
> SQLPLUSW.EXE scott/tiger_at_host @D:\script.sql
>
> script.sql:
> SET LINESIZE 2000
> set colsep ,
>
> spool D:\file.txt
> select * from emp;
> spool off;
> exit
>
> The result is odd, i have a header with the columns title separated by
> commas then a line with ------ and then11 lines of data and again the header
> and so on.
> It seems also to be size delimited
>
> EMPNO,ENAME ,JOB , MGR,HIREDATE ,
> ----------,----------,---------,----------,---------,
> 7369,SMITH ,CLERK , 7902,17-DEC-80,
>
> Is there a way to remove the header and the ---- separation? also to remove
> this size delimitation?
> in a way to have only:
>
> 7369,SMITH,CLERK,7902,17-DEC-80,
>
> Thanks
>
>

use the following:

SET HEADING OFF HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown