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:

search engine

Custom Search