设置oracle 连接提示符

[oracle@test admin]$ pwd

/u01/app/oracle/product/12.2.0/dbhome_1/sqlplus/admin

修改文件glogin.sql

[oracle@test  admin]$ ls
glogin.sql  help  libsqlplus.def  plustrce.sql  pupbld.sql
[oracle@test admin]$ vi glogin.sql

添加

set linesize 120
set pagesize 999
define _editor=vi
set sqlprompt "_user'@'_connect_identifier> "

[oracle@test admin]$ sqlplus /nolog


SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 1 14:36:24 2017


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


@> conn /as sysdba
Connected.
SYS@PROD> 

登录后提示符就会变成用户名加链接提示符