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

R is not a simple programming language, and it does better on reading excel files than python

R is not a simple programming language, and it does better on reading excel files than python . tried to read excel files to python and R. i...