Wednesday, June 12, 2013

how to spool xls file in oracle sqlplus


[prompt#] sqlplus / as sysdba

SQL> set markup html on;

SQL> spool details.xls 

SQL> select * from v$session;

SQL>spool off

SQL>exit


No comments:

Post a Comment