Re: SQL Results.

On Wed, 26 Jul 2000 15:09:02 GMT, pmohanan_at_my-deja.com wrote:

>Hi...All,
> Here is an SQL stmt :
>
>set hea off;
>set arraysize 1;
>set pages 5000;
>spool abc.txt;
>
>select f1, f2, f3 from test;
>spool off;
>
>I execute the sql as
>sqlplus $USRPASS _at_test.sql
>
>If I open the file abc.txt, there is a blank line at the top. How do i
>avoid that.
>
>Regards,
>Praveen

Set pagesize to zero will do:

set pages 0

Henk-Jan Visscher
visscher_at_aedius.com Received on Thu Jul 27 2000 - 00:00:00 CEST