Saturday, June 22, 2013

How to export table data in oracle from sqlplus prompt with excel file format



Login at sqlplus  and execute the below steps,


SQL> set feed off markup html on spool on\

SQL> spool 'd:\filename.xls'

SQL> select * from table_name ;--Your query

SQL> spool off

SQL> set markup html off spool off

Thanks,
Kaziul Islam Bulbul
Dhaka, Bamgladesh

No comments:

Post a Comment