Oracle修改提示符方法sqlplus启动的时候会读取glogin.sql脚本，在$Oracle_HOME/sqlplus/admin目录中，写在里面就可以了。给你个例
Oracle修改提示符方法
sqlplus启动的时候会读取glogin.sql脚本，，在$Oracle_HOME/sqlplus/admin目录中，写在里面就可以了。
给你个例子。
[php]
—
— Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.
—
— NAME
— glogin.sql
—
— DESCRIPTION
— SQL*Plus global login startup本文来源gaodai#ma#com搞@@代~&码网 file.
—
— Add any sqlplus commands here that are to be executed when a user
— starts SQL*Plus on your system
—
— USAGE
— This script is automatically run when SQL*Plus starts
—
— For backward compatibility
SET SERVEROUTPUT ON SIZE 1000000
SET TRIMSPOOL ON
SET LONG 5000
SET LINESIZE 100
SET PAGESIZE 9999
SET SQLPLUSCOMPATIBILITY 8.1.7
COLUMN global_name new_value gname
SET TERMOUT OFF
select lower(user) || ‘@’ || decode(global_name,’Oracle8.WORLD’,’8.0′,’ORA8I.WORLD’,’8i’,global_name) global_name from global_name;
SET SQLPROMPT ‘&gname>’
SET TERMOUT ON
— 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
— 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 SET AUTOTRACE EXPLAIN report
COLUMN id_plus_exp FORMAT 990 HEADING i
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
COLUMN plan_plus_exp FORMAT a80
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp FORMAT a29
COLUMN other_plus_exp FORMAT a44
[/php]
D:\Temp>;sqlplus
SQL*Plus: Release 9.2.0.4.0 – Production on Tue Dec 16 12:07:06 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: scott/[email protected]
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 – Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 – Production
Welcome to Seraphim’s SQL*PLUS!
You are connected to ORA921.IAGENT as SCOTT
SQL>;
实现这种效果，在glogin.sql中加入以下行：
set heading off
prompt Welcome to Seraphim’s SQL*PLUS!
select ‘You are connected to ‘ || global_name || ‘ as ‘ || user from global_name;
set serveroutput on
set heading on
或
COLUMN host_name new_value hname
SET TERMOUT OFF
select SYS_CONTEXT(‘USERENV’,’HOST’) host_name from dual;
SET SQLPROMPT ‘&hname>;’
SET TERMOUT ON
转载请注明原文链接：Oracle修改提示符方法
