oracle提示符,ORACLE提示符

ORACLE提示符

目的：修改sqlplus的提示符，方便查看当前用户

查看当前用户

SQL> show user

USER is "SYS"

当前会话修改提示符

SQL> set sqlprompt "_user'@'_connect_identifier> "

SYS@PROD>

全局修改提示符

[oracle@test ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/      #ORACLE_HOME/sqlplus/admin/

[oracle@test admin]$ ls

glogin.sql  help  libsqlplus.def  plustrce.sql  pupbld.sql

[oracle@test admin]$ vi glogin.sql

--

-- Copyright (c) 1988, 2011, Oracle and/or its affiliates.

-- All rights reserved.

--

-- NAME

--   glogin.sql

--

-- DESCRIPTION

--   SQL*Plus global login "site profile" file

--

--   Add any SQL*Plus commands here that are to be executed when a

--   user starts SQL*Plus, or uses the SQL*Plus CONNECT command.

--

-- USAGE

--   This script is automatically run

--

set sqlprompt "_user'@'_connect_identifier> "

~

"glogin.sql" 18L, 415C written

[oracle@test admin]$

注：glogin.sql为sqlplus的全局登陆时的参数，可以在其他目录创建login.sql，当在该目录打开sqlplus的时候，读取该目录的login.sql