sqlplus顯示登入使用者名稱和例項名

yhj20041128001發表於2013-08-29
SQL
1.Entry $ORACLE_HOME/sqlplus/admin,edit glogin.sql,add as follow SQL statement behind.

[hrmsoraclone@hrmodbt01 admin]$cp  glogin.sql  glogin.sql.bak
[hrmsoraclone@hrmodbt01 admin]$vi glogin.sql
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
2.when entry sqlplus,it show as follow
 
[hrmsoraclone@hrmodbt01 admin]$ sql
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 29 09:50:56 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23757700/viewspace-769474/，如需轉載，請註明出處，否則將追究法律責任。

相關文章