Oracle: SQLplus Prompt to show user, connection (10g)

SQLplus Prompt to show user, connection (Oracle 10g)

run the following in sqlplus:

set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> "


Display:
user@DB (privilege if exist)>

No comments: