Sunday, 20 January 2013

Get output of a query to a text file from SQL Plus | Oracle DBA Tutorial pdf


Get output of a query to a text file from SQL Plus

set pagesize 5000
set linesize 5000
spool F:\TEMP\OUTPUT.TXT
set colsep "|"
select * from MKM.PRODUCT;
set colsep " "
spool off
set pagesize 50
set linesize 200

No comments: