Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to find database name...

867965Jul 9 2011 — edited Jul 9 2011
Hi guys,

How to find the database name of a particular user?

i know how to find the database name of currently connected user.
select name from v$database;
i connect to sys user, and query the list of user by
select * from all_users;
from the above query i get all username but i cant get database name. so which query to get username as well as database name?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2011
Added on Jul 9 2011
3 comments
386 views