SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

csv file generation without display

Ramesh RFeb 1 2011 — edited Feb 1 2011

Hi,
I have a scenario like to create a csv file as an output of a query. I have two clarificaitions
i will spool the output like

spool output_file.csv;
select * from emp;

I am running the same thro a putty in linux server.
I want the output of the query in the spooled file but the outptu shoud not be selected to me, because the nuber of records is quite more (around 2 million records) which should not scrool in my puttty prompt..i want th equery to run in silent mode . Is there a way to do so. Help on the same

Thanks
Ramesh.R

This post has been answered by Sven W. on Feb 1 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2011

Added on Feb 1 2011

9 comments

1,616 views