Possible Duplicate:
Create an Excel Spreadsheet from a Oracle Database
how can i export result of select statement to CSV format in oracle, please in pl/sql thanks
Asked
Active
Viewed 3,681 times
-2
Community
- 1
- 1
mauriyouth
- 61
- 1
- 10
1 Answers
1
if you use a tool like sql developer, or toad, or SqlNavigator you have option for saving the results of a query. If you use sqlplus, you can use spool command.( How do I spool to a CSV formatted file using SQLPLUS?) What's your case?
Community
- 1
- 1
Florin Ghita
- 17,525
- 6
- 57
- 76
-
i have toad; but it's an automated query (batch) i want to save the result on csv file – mauriyouth Jul 27 '11 at 13:43
-
ok, so you can use the link from my response, if the batch is run with sqlplus. Isn't it? – Florin Ghita Jul 28 '11 at 08:12