sqlplus env setting 环境变量设置

我的SQLPLUS环境设置 --来自 Oracle9i&10g 编程艺术
set serveroutput on size 1000000

set trimspool on
set linesize 200
set pagesize 9999 --if 0 then no title

set feedback off
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set feedback on
set timing on
set time on
set lines 132
set pages 999
set long 2000000
set timing on
set serveroutput on size 1000000
col object_name format a32
col column_name format a32
col index_name format a32
col file_name format a54
col db_link format a32
col plan_plus_exp format a80

column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select lower(user) || '@' || substr( global_name, 1, decode( dot, 0,
length(global_name), dot-1) ) global_name
from (select global_name, instr(global_name,'.') dot from global_name );
set sqlprompt '&gname> '
set termout on

--------TBSITE

-- Used by Trusted Oracle
COLUMN ROWLABEL FORMAT A15

-- Used for the SHOW ERRORS command
COLUMN LINE/COL FORMAT A8
COLUMN ERROR FORMAT A65 WORD_WRAPPED

-- Used for the SHOW SGA command
COLUMN name_col_plus_show_sga FORMAT a24
COLUMN units_col_plus_show_sga FORMAT a15
-- Defaults for SHOW PARAMETERS
COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME
COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE

-- Defaults for SHOW RECYCLEBIN
COLUMN origname_plus_show_recyc FORMAT a16 HEADING 'ORIGINAL NAME'
COLUMN objectname_plus_show_recyc FORMAT a30 HEADING 'RECYCLEBIN NAME'
COLUMN objtype_plus_show_recyc FORMAT a12 HEADING 'OBJECT TYPE'
COLUMN droptime_plus_show_recyc FORMAT a19 HEADING 'DROP TIME'

-- Defaults for SET AUTOTRACE EXPLAIN report
-- These column definitions are only used when SQL*Plus
-- is connected to Oracle 9.2 or earlier.
COLUMN id_plus_exp FORMAT 990 HEADING i
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
COLUMN plan_plus_exp FORMAT a60
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp FORMAT a29
COLUMN other_plus_exp FORMAT a44

-- Default for XQUERY
COLUMN result_plus_xquery HEADING 'Result Sequence'

SET TIME ON
SET TIMING ON
SET SQLPROMPT "_USER@ _CONNECT_IDENTIFIER>"

set termout off
set feedback off
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set feedback on
set termout on

This work is licensed under a CC A-S 4.0 International License.