Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

write a result table from a SELECT statement in a file

Status
Not open for further replies.
AnnieSt

AnnieSt

Programmer
Apr 8, 2003
1
CA
Hi,

I want to create a SQL script to select data from a specific table and send the result in a file with a specific format like .CSV. I'm using SQL +.

Thank you.

Annie
 
Sort by date Sort by votes
set pages 0
set colsep ,
set feedback off
spool <your file name>
select ...
/
spool off

Regards, Dima
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spd800c
  • Locked
  • Question
GIF icons not showing at runtime in Developer 10g
Replies
0
Views
127
spd800c
spd800c
BJCooperIT
  • Locked
  • Question
Problem running a form from Forms Builder
Replies
2
Views
184
BJCooperIT
BJCooperIT
Maahjoor
  • Locked
  • Question
apllication screen adjustment problem
Replies
0
Views
127
Maahjoor
Maahjoor
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
154
oradba101
oradba101
bookouri
  • Locked
  • Question
storing constants in a configuration file
Replies
1
Views
69
bookouri
bookouri

Part and Inventory Search

Sponsor

Back
Top