61 lines
2.2 KiB
SQL
61 lines
2.2 KiB
SQL
set appinfo OFF
|
|
set appinfo "SQL*Plus"
|
|
set arraysize 500
|
|
set autocommit OFF
|
|
set autoprint OFF
|
|
set autorecovery OFF
|
|
set autotrace OFF
|
|
set blockterminator "."
|
|
set cmdsep OFF
|
|
set colsep " "
|
|
set compatibility NATIVE
|
|
set concat "."
|
|
set copycommit 0
|
|
set copytypecheck ON
|
|
set define "&"
|
|
set describe DEPTH 1 LINENUM ON INDENT ON
|
|
set echo OFF
|
|
set editfile "afiedit.sql"
|
|
set embedded OFF
|
|
set escape OFF
|
|
set escchar OFF
|
|
set feedback 6
|
|
set flagger OFF
|
|
set flush ON
|
|
set heading ON
|
|
set headsep "|"
|
|
set linesize 299
|
|
set logsource ""
|
|
set long 10000000
|
|
set longchunksize 10000000
|
|
set markup HTML OFF HEAD "<style type='text/css'> BODY{ font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} P { font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} TABLE,TR,TD { font:10pt Arial,Helvetica,sans-serif; color:black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; white-space:nowrap;} TH { font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} H1 { font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} H2 { font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} </style> <title>SYS@rac01/rac112 report</title>" BODY "" TABLE "border='1' align='center' summary='Script output'" SPOOL ON ENTMAP ON PRE OFF
|
|
set newpage 1
|
|
set null ""
|
|
set numformat ""
|
|
set numwidth 10
|
|
set pagesize 5000
|
|
set pause OFF
|
|
set recsep WRAP
|
|
set recsepchar " "
|
|
set serveroutput OFF
|
|
set shiftinout invisible
|
|
set showmode OFF
|
|
set sqlblanklines OFF
|
|
set sqlcase MIXED
|
|
set sqlcontinue "> "
|
|
set sqlnumber ON
|
|
set sqlpluscompatibility 10.2.0
|
|
set sqlprefix "#"
|
|
set sqlprompt "SQL> "
|
|
set sqlterminator ";"
|
|
set suffix "sql"
|
|
set tab OFF
|
|
set termout OFF
|
|
set time OFF
|
|
set timing OFF
|
|
set trimout ON
|
|
set trimspool ON
|
|
set underline "-"
|
|
set verify OFF
|
|
set wrap ON
|