Skip to Main Content

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!

How to SPool the data to an output .CSV or .TXT file

2809066Dec 11 2014 — edited Dec 11 2014

Hi,

I have written a query say

Select * from tablename;

now, i get the output

Query Result:

===============

column1 column2

1         2

3         4

5         6

and so on. How i can spool the output(query result) to C:\newfolder\Extraction.TXT or C:\newfolder\Extraction.CSV

Please note that the output records are high in number.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2015
Added on Dec 11 2014
6 comments
7,595 views