exceloracle-databaseexportoracle-sqldeveloper

How to export select query data into excel file using Oracle query?

I have a query which generates reports for a particular day. Is there any query where in Oracle with export it into excel? I dont want to manually export it. Am using oracle developer.

Solution

  • You need to use SPOOL and you can not directly write to .xls file, You need to write data to .csv file and open it in Excel.

    set sqlformat csv
spool d:\your_file.csv
select * from your_table;
spool off;

    Cheers!!