Monday, 11 May 2015

How to generate from text file to excel Format?

set pagesize 10000
set feedback off
set echo off
set colsep ','
set linesize 10000
spool filename1.csv
query here.....(give SQL query:ex:select * from ........)
spool off

No comments:

Post a Comment