top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
85 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 Google+ Share Button LinkedIn Share Button Multiple Social 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...