Exporting result of select statement to CSV format [duplicate]

Possible Duplicate:

Create an Excel Spreadsheet from a Oracle Database

how can i export result of select statement to CSV format in oracl开发者_开发知识库e, please in pl/sql thanks

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?