定製sql*plus的幾條命令

sql*plus每次啟動前會執行$ORACLE_HOME/sqlplus/admin/login.sql (glogin.sql)檔案，修改該檔案內容可以在每次進入sql*plus是進入自己定製的模式中。[@more@]

一個glogin.sql檔案例子：

set serveroutput on size 100000

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
select lower(user)||'@'||decode(global_name,'ORCL.US.ORACLE.COM','ORCL',global_name) global_name from global_name;
set sqlprompt '&gname>'
set termout on

進入sql*plus時，介面如下（各set/column命令不逐條解釋）：

U:>sqlplus scott/tiger

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 2月 1 20:56:01 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

連線到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

>