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