sqlplus在启动时会自动运行两个脚本文件:glogin.sql、login.sql;

这里只在 glogin.sql 【全局设定】中配置相关参数。

19c中glogin.sql 默认目录

$ORACLE_HOME/sqlplus/admin/glogin.sql

设置SQLPLUS提示符，显示格式为用户@数据库名 

-- Copyright (c) 1988, 2005, Oracle.  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
--
--_user 代表当前登陆用户名
--_connect_identifier 代表当前数据库连接串名
--在glogin.sql中设置全局sqlplus提示符user和connect
--identifier是sqlplus的默认变量
set sqlprompt "_user'@'_connect_identifier> "

实现效果

SYS@b19c01> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
SYS@b19c01> alter session set container=pdb1;

Session altered.

SYS@b19c01> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 PDB1                           READ WRITE NO
SYS@b19c01> conn scott/tiger@pdb1;
Connected.
SCOTT@pdb1>

>>>如果文章对你有所帮助，欢迎关注、点赞、收藏、评论，谢谢！<<<