My Work
Monday, July 21, 2008
CHANGE SQLPROMPT TO REFLECT USER
We can set the SQL*Plus prompt to reflect the username instead of
SQL>
.
Use these SQL*Plus commands:
column D22 new_value VAR
select username D22 from user_users;
set sqlprompt '&&VAR>'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
search engine
Custom Search
No comments:
Post a Comment