修改 sqlplus 提示符

[root@atyu30 bin]# find / -name glogin.sql
/usr/lib/oracle/11.1.0.1/client64/lib/glogin.sql
[root@atyu30 lib]# vi /usr/lib/oracle/11.1.0.1/client64/lib/glogin.sql

-- Default for atyu30
define_editor=vi
set timing on
set serveroutput on size 100000
set linesize 100
set trimspool on
set long 5000
set termout off
default gname=idle
column global_name new_value gname
SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NAME FROM v$instance;
set sqlprompt '&gname> '
set termout on

[root@atyu30 lib]# sqlplus atyu30/[email protected]:1521/atyu30

SQL*Plus: Release 11.1.0.6.0 - Production on 星期日 9月 26 01:00:59 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

atyu30@ATYU30(127.0.0.1)>