oracle自带的sql语言环境变量,SQLPLUS环境变量设置

在ORACLE_HOME\SQLPLUS\ADMIN 下有一个GLOIN.SQL文件，在每次启动SQLPLUS时候都会自动运行此脚本。为了以后练习方便，把常用的环境变量加到这个文件当中，就不用每次的设置。

WIN2003上如下：

D:\oracle\product\10.2.0\db_1\sqlplus\admin\glogin.sql

--

-- Copyright (c) 1988, 2004, Oracle Corporation.  All Rights

Reserved.

--

-- NAME

--   glogin.sql

--

-- DESCRIPTION

--   SQL*Plus

global login "site profile" file

--

--   Add any SQL*Plus commands here

that are to be executed when a

--   user starts SQL*Plus, or uses the

SQL*Plus CONNECT command

--

-- USAGE

--   This script. is automatically

run

--

-- 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'

define _editor=notepad

set serveroutput on size 1000000

set trimspool on

set long 5000

set linesize 100

set pagesize 9999

column 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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15720542/viewspace-743326/，如需转载，请注明出处，否则将追究法律责任。