11 Replies Latest reply on Dec 2, 2010 11:58 PM by SomeoneElse

    sqlplus, how to stop output to console

    764712
      Hi,
      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