Forum Stats

  • 3,758,202 Users
  • 2,251,352 Discussions
  • 7,870,107 Comments

Discussions

Different prompts in sqlplus and sqlcl

3629179
3629179 Member Posts: 3
edited Apr 1, 2019 8:48AM in SQLcl

I have primary and standby database with ORACLE_SID's XXX_S1 and XXX_S2.

I defined in glogin.sql my prompt as:

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE > "

I use both sqlplus and sqlcl.

In sqlplus i see the prompt I expected:

sqlplus / as sysdba

[email protected]_S1 AS SYSDBA >

but when i use sqlcl i see only:

sql / as sysdba

[email protected] AS SYSDBA >

Why "_S1" dissapeared?

Answers