ezoic

Wednesday, August 24, 2016

How to output oracle sql results to a file without showing the results on screen

SET TERMOUT OFF;
SET WRAP OFF;
set pagesize 0;

SET COLSEP '|'
SET LINESIZE 32767

set trimspool on

spool C:\XXX\a.txt
select fox_id,fox_version_id, fin_prod_id, title_desc from zr_edm_global_title where rownum<500 ;

spool off;
exit;
the above statement can output oracle sql results to a file without showing the results on screen, and the output will be shown line by line. 


No comments:

Post a Comment

looking for a man

 I am a mid aged woman.  I was born in 1980. I do not have any kid. no complicated  dating before . I am looking for a man here for marriage...