default_settings.sql
SQL*Plusのデフォルト設定
各スクリプトの最後で読み込む
code:SQL
set appinfo OFF
set appinfo "SQL*Plus"
set arraysize 15
set autocommit OFF
set autoprint OFF
set autorecovery OFF
set autotrace OFF
set blockterminator "."
set cmdsep OFF
set colinvisible OFF
set coljson 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 6
set flagger OFF
set flush ON
set fullcolname OFF
set heading ON
set headsep "|"
set linesize 80
set lobprefetch 0
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 markup CSV OFF DELIMITER , QUOTE ON
set newpage 1
set null ""
set numformat ""
set numwidth 10
set pagesize 1000
set pause OFF
set recsep WRAP
set recsepchar " "
set rowlimit OFF
set rowprefetch 1
set securedcol OFF
set serveroutput OFF
set shiftinout invisible
set showmode OFF
set sqlblanklines OFF
set sqlcase MIXED
set sqlcontinue "> "
set sqlnumber ON
set sqlpluscompatibility 19.0.0
set sqlprefix "#"
set sqlprompt "SQL> "
set sqlterminator ";"
set statementcache 0
set suffix "sql"
set tab OFF
set termout ON
set time ON
set timing ON
set trimout ON
set trimspool OFF
set underline "-"
set verify ON
set wrap ON
set xmloptimizationcheck OFF
clear break