65 lines
2.1 KiB
SQL
65 lines
2.1 KiB
SQL
set appinfo OFF
|
|
set appinfo "SQL*Plus"
|
|
set arraysize 5000
|
|
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 OFF INDENT ON
|
|
set echo OFF
|
|
set editfile "afiedt.buf"
|
|
set embedded OFF
|
|
set escape OFF
|
|
set escchar OFF
|
|
set exitcommit ON
|
|
set feedback ON
|
|
set flagger OFF
|
|
set flush ON
|
|
set heading ON
|
|
set headsep "|"
|
|
set linesize 80
|
|
set logsource ""
|
|
set long 80
|
|
set longchunksize 80
|
|
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;} 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>SQL*Plus Report</title>" BODY "" TABLE "border='1' width='90%' align='center' summary='Script output'" SPOOL OFF ENTMAP ON PRE OFF
|
|
set newpage 1
|
|
set null ""
|
|
set numformat ""
|
|
set numwidth 10
|
|
set pagesize 80
|
|
set pause OFF
|
|
set recsep WRAP
|
|
set recsepchar " "
|
|
set securedcol OFF
|
|
set serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
|
|
set shiftinout invisible
|
|
set showmode OFF
|
|
set sqlblanklines ON
|
|
set sqlcase MIXED
|
|
set sqlcontinue "> "
|
|
set sqlnumber ON
|
|
set sqlpluscompatibility 11.2.0
|
|
set sqlprefix "#"
|
|
set sqlprompt "bt01pimi1: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 ON
|
|
set wrap ON
|
|
set xmloptimizationcheck OFF
|