wsr13990
4/28/2019 - 6:17 PM

spool to xls using sqlplus

spool.sh
content_copyfile_download
#Spool from sqlplus
sqlplus -s hum/hum@OPRAFM<<!
SET SERVEROUTPUT ON;
set echo on
SET PAGESIZE 40000
SET FEEDBACK OFF
SET MARKUP HTML ON
SET NUM 24
SPOOL "/tmp/count_result_OPRFAM.xls"
select * from count_row;
spool off
exit;
!