sqlplus, how to stop output to console
764712Dec 1 2010 — edited Dec 2 2010Hi,
I'm running the script to unload table into the file, and it works fine, myfile.dat getting its data,
I just want to stop rows I'm getting written into console display, anybody knows what option I can use for that?
That's what I haev inside my ksh:
sqlplus username/password@$_SID <<EOF
set colsep ,
set pagesize 0
set trimspool on
set headsep off
set linesize 150
spool /tmp/myfile.dat
SELECT COL1 FROM TABLE1
EOF
Tx
Trent