SQL*PLUS simple problem... 
Author Message
 SQL*PLUS simple problem...

Hello all,
    I have a problem about SQL*PLUS.
    I have the following sql file:

    set arraysize 2
    set linesize 100
    set pagesize 100
    set space 0
    set heading off
    set feedback off
    spool aaa.txt
    select * from emp;
    spool off

    The output is stored in aaa.txt. However, I find that there is one
blank line at the beginning of aaa.txt. What should I set in SQL*PLUS
such that there is no blank line at the beginning of file aaa.txt?

Thanks,
Jimmy



Tue, 23 Oct 2001 03:00:00 GMT
 SQL*PLUS simple problem...

If you set pagesize 0 then you will not get the blank line. You can also
remove 'set heading off' because the heading is not printed if you set the
pagesize to 0.

Geoff

Quote:

> Hello all,
>     I have a problem about SQL*PLUS.
>     I have the following sql file:

>     set arraysize 2
>     set linesize 100
>     set pagesize 100
>     set space 0
>     set heading off
>     set feedback off
>     spool aaa.txt
>     select * from emp;
>     spool off

>     The output is stored in aaa.txt. However, I find that there is one
> blank line at the beginning of aaa.txt. What should I set in SQL*PLUS
> such that there is no blank line at the beginning of file aaa.txt?

> Thanks,
> Jimmy



Tue, 23 Oct 2001 03:00:00 GMT
 SQL*PLUS simple problem...
set pages 0
--

 * Bank "Grant", Kharkov, Ukraine



:     I have a problem about SQL*PLUS.
:     I have the following sql file:
:
:     set arraysize 2
:     set linesize 100
:     set pagesize 100
:     set space 0
:     set heading off
:     set feedback off
:     spool aaa.txt
:     select * from emp;
:     spool off
:
:     The output is stored in aaa.txt. However, I find that there is
one
: blank line at the beginning of aaa.txt. What should I set in SQL*PLUS
: such that there is no blank line at the beginning of file aaa.txt?



Tue, 23 Oct 2001 03:00:00 GMT
 SQL*PLUS simple problem...
Jimmy,

You need to add the following:

set pagesize 0

That should do the trick.

Karl

Quote:

>Hello all,
>    I have a problem about SQL*PLUS.
>    I have the following sql file:

>    set arraysize 2
>    set linesize 100
>    set pagesize 100
>    set space 0
>    set heading off
>    set feedback off
>    spool aaa.txt
>    select * from emp;
>    spool off

>    The output is stored in aaa.txt. However, I find that there is one
>blank line at the beginning of aaa.txt. What should I set in SQL*PLUS
>such that there is no blank line at the beginning of file aaa.txt?

>Thanks,
>Jimmy



Tue, 23 Oct 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Oracle*&SQL*Plus 8.0/Net8 versus Designer&SQL*Plus 3.x/SQL*Net

2. MS Access 97 SQL to MS SQL SQL SQL SQL

3. Oracle 7.3: problem running SQL script with SQL*Plus

4. 14133-NY-Rochester-ORACLE-UNIX-SQL*Plus-PL/SQL-SQL-Analyst

5. 14133-NY-Rochester-ORACLE-UNIX-SQL*Plus-PL/SQL-SQL-Analyst

6. 14133-NY-Rochester-ORACLE-UNIX-SQL*Plus-PL/SQL-SQL-Analyst


 
Powered by phpBB® Forum Software