Friday, November 11, 2011

sqlplus switch off all output for command line


Example of code, take a look for bold parts:

sqlplus -s $DATABASE_LOGON <<EOF
  set termout off
  set echo off  
  set trimspool on
  set feedback off
  set show off

  set linesize 200
  set pagesize 1000

  spool $OUTPUT_FILE
  @$JOB__SQL_FILE_NAME.sql
  spool off
  exit;
EOF

No comments:

Post a Comment