原文链接:
在oracle编程艺术开篇配置环境中提到login.sql,就是用来建立sqlplus环境的。要让它自动运行,这个东西应该放到哪去呢?如果登录sqlplus时当前目录存在,就先查看当前目录下是否存在login.sql,如果没有就去查看SQLPATH/login.sql,而ORACLE_HOME/sqlplus/admin/glogin.sql则是对全局都有效的配置设置。所以,把login.sql里边的内容放到glogin.sql倒是偷懒的办法。login.sql内容如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
define _editor=vi
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
|
http://bonyfish.cn/logs/20091002-sqlplus-login-sql.html