how to get schema corresponding database name

[ramanan ram]

how to get schema corresponding database name?
select * from v$database this query only to show current databse name ,but i need databse name corresponding schemas

how this possible

[rski]

select * from v$database this query only to show current databse name ,but i need databse name corresponding schemas

Do you mean you want all defined schemas? if so you can do

select * from dba_users;

[ramanan ram]

your answer is ok thank u
now the question is, i am using 3 host EX:PRMY each host contains some of dba_users ex: etrans3103,SA .i need if the host is PRMY it display all PRMY users like another host users. i need that query

regards
Ramanan