top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to see current user name and to Change SQL prompt name in Oracle?

+1 vote
323 views
How to see current user name and to Change SQL prompt name in Oracle?
posted Mar 10, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

to see the user : Sql> show user;

to change the prompt name: SQL> set sqlprompt “Manimara > “
Manimara >

answer Mar 11, 2015 by Arun Gowda
...