Oracle

removing first blank line in csv file

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2009

Posts: 33

Reputation: axeeffect2002 is an unknown quantity at this point

Solved Threads: 4

axeeffect2002 axeeffect2002 is offline

Offline

Light Poster

removing first blank line in csv file

Sep 21st, 2009

Hi,
I have written a sql script which takes the rows from a table and writes it to
a .csv file.

The script is as follows:-

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
 SET feedback off;
 spool output.csv;
 SET heading off;
 SELECT username||','||profession FROM users;
 spool off;
 set feedback off;
 spool output.csv;
 set heading off;
 SELECT username||','||profession from users;
 spool off;

This works fine but output.csv contains a blank line at the top.
How can I get rid of that blank line?

Thanks in advance

Add to my reputation if you think I really helped you. :)

•

Join Date: Sep 2009

Posts: 2

Reputation: babyDBA is an unknown quantity at this point

Solved Threads: 2

babyDBA

Offline

Newbie Poster

Re: removing first blank line in csv file

Sep 23rd, 2009

You have to add command SET PAGESIZE 0 at the top script

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SET PAGESIZE 0       -- <-- add this line
 
SET FEEDBACK OFF
SET HEADING OFF
 
SPOOL OUTPUT.TXT;
SELECT username||','||profession FROM users;
SPOOL OFF;
SET PAGESIZE 0       -- <-- add this line

SET FEEDBACK OFF
SET HEADING OFF

SPOOL OUTPUT.TXT;
SELECT username||','||profession FROM users;
SPOOL OFF;