Tuesday, October 6, 2009

How to export single table xls format?

Export single table xls format:
We can use use third party tools like toad,plsql developer etc.. to export table data in xls format .
In toad
1.excute query
2.right click and select save as and choose XLS format

Following procedure can be used for single table export in xls format.

SET ECHO OFF
SET TERMOUT OFF
SET FEEDBACK OFF
SET TIMING OFF
SET PAUSE OFF
SET PAGESIZE 0
SET LINESIZE 255
SET TRIMSPOOL ON
spool table.xls
set feed off markup html on spool on
@@your Sql
set markup html off spool off

No comments: