You want to see your connected user name in SQL*PLUS command prompt
SOLUTION:
You need to edit your glogin.sql file located in the following path:
oracle_home\product\11.2.0\dbhome_1\sqlplus\admin\glogin.sql
Add to the original file contents the following lines:
set serveroutput on prompt hello! set lines 120 pages 120 set sqlprompt '_user> '
If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!
Hi, nice command about how to Show connected user in Oracle SQL*PLUS command prompt.Thanks,its extemely helped me....
ReplyDelete-Aparna
Theosoft