Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within Oracle/OAS
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Tim Cooke
paul wheaton
Ron McLeod
Jeanne Boyarsky
Sheriffs:
Paul Clapham
Saloon Keepers:
Tim Holloway
Roland Mueller
Bartenders:
Forum:
Oracle/OAS
removing first blank line in csv file
nandini lagunia
Ranch Hand
Posts: 57
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
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:-
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
Christophe Verré
Sheriff
Posts: 14691
16
I like...
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
You could use SET NEWPAGE NONE;
[My Blog]
All roads lead to JavaRanch
This is awkward. I've grown a second evil head. I'm going to need a machete and a tiny ad ...
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
Running a .bat/ .cmd file from Java
PL / SQL to create synonyms for all tables
oracle 9i
ORA-22950: cannot ORDER objects without MAP or ORDER method
Use PL/SQL Loop and variable
More...