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