Skip to Main Content
Forums

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!

Writing data to Text file

TheleoOct 24 2012 — edited Oct 29 2012
Hello,

I have to write sql query results to a folder on the Network drive

I am trying to use spool command.

Issues I am facing

1 ) Spool file showing sql query ( which I do not want to show )
2 ) I have sql of 250 Fields in select query , so Data spreading across multiple lines.

Please Let me know how do I do to have nice format !!

I can not Use UTL_File , Probably that is not Setup yet.

thanks !!

Edited by: Theleo on Oct 24, 2012 1:56 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2012
Added on Oct 24 2012
11 comments
1,022 views