select * from dba

when loggined as SYSTEM,how to display all the users of database using sql query?

Question Posted / phan wai keong

Answer Posted / phan wai keong

select * from dba_users;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we create trigger on materialized view in oracle?

995

What do you know about normalization? Explain in detail?

952

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2398

How to divide query output into groups in oracle?

992

What is translate in oracle?

1100

How to drop an existing table in oracle?

1058

what is a Nested Loop join?

2119

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2347

What happens if recursive calls get out of control?

1083

Is there any function in oracle similar like group_concat of mysql?

1054

How to load excel data sheet to oracle database

1029

What is a dynamic performance view in oracle?

995

How to retrieve the count of updated rows?

1128

Is primary key indexed by default in oracle?

988

What is a select query statement in oracle?

970