Showing posts with label sqlplus output off shell terminal. Show all posts
Showing posts with label sqlplus output off shell terminal. Show all posts

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