How to redirect the seleced output or table data to a file in oracle database?

[archana amith]

Hi,

I have a table in Oracle.

Here is the table.

SQL> select * from test;

       SDI NAME
---------- ---------------
       123 Tapas
       345 PradEEp
       567 Jagadish
       789 Giri

I want write this data into a CSV file. I tried this but i am not able to redirect or write to the file.

Here is the Query.

SELECT name INTO OUTFILE "/orahome/test.csv" from test;
Error:
ORA-00923: FROM keyword not found where expected

How can i write the data to file or redirect the data to file in Oracle?

Regards

[debasisdas]

try this

SQL> spool c:\test.txt
SQL> SELECT * FROM test;
SQL> spool off