Forum Stats

  • 3,824,920 Users
  • 2,260,440 Discussions
  • 7,896,347 Comments

Discussions

Sqlprompt in sqlcl is not cleared after disconnection from a database.

User_RRL4F
User_RRL4F Member Posts: 2 Red Ribbon

SQLcl: Release 22.1 Production on Fri Jun 03 13:13:14 2022

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

@> set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "

@> conn [email protected]

Password? (**********?) ********************

Connected.

[email protected]> disconnect

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0

[email protected]

Since I have already disconnected from the database, it would be right if sqlprompt was also cleared.

Sqlplus clears sqlprompt after disconnection from the database.