top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+2 votes
487 views

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

posted Jun 1, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

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

answer Jul 17, 2014 by Pradeep Kumar
...