A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
removing first blank line in csv file
Joined: May 05, 2009
Sep 21, 2009 10:38:10
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:-
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
Joined: Nov 24, 2005
Sep 25, 2009 02:58:32
You could use SET NEWPAGE NONE;
All roads lead to JavaRanch
I agree. Here's the link:
subject: removing first blank line in csv file
ORA-22950: cannot ORDER objects without MAP or ORDER method
Use PL/SQL Loop and variable
PL / SQL to create synonyms for all tables
Running a .bat/ .cmd file from Java
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014