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)>
Display:
user@DB (privilege if exist)>
Repository of Database Related Information, Assets and Knowledge Base covering Oracle, SQLs, Scripts, Performance Tuning etc
No comments:
Post a Comment