Wednesday, October 24, 2012

Show connected user in Oracle SQL*PLUS command prompt

PROBLEM:
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!

1 comment:

  1. Hi, nice command about how to Show connected user in Oracle SQL*PLUS command prompt.Thanks,its extemely helped me....

    -Aparna
    Theosoft

    ReplyDelete