Is there any way of creating a csv file from the data of a table in oracle

Question

I want to genarate a csv report from the data of a table, can i do this without creating a directory.

Answer 1

We can create csv file from the data of a table in oracle without directory.

ex:

spool C:\Users\PRADEEP\Desktop\emp.csv

select * from emp;

spool off