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

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

Question Posted / saiprasannach89

2 Answers
3904 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / phan wai keong

select * from dba_users;

Is This Answer Correct ?

6 Yes

0 No

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

Answer / pradeep

select * from all_users;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Oracle General Interview Questions

what is the difference between oracle enterprise edition and oracle express edition?

What is the difference between Sleep and Wait? (Java)

How to load excel data sheet to oracle database

What happens if you set the sga too low in oracle?

Is there an oracle sql query that aggregates multiple rows into one row?

What is the difference between column level constraints and table level constraints?

14 Answers IBM, TCS,

What are set operators?

How many memory layers are in the oracle shared pool?

Query to retrieve record for a many to many relationship ?

0 Answers Keane India Ltd,

what is the difference between sql& oracle?

11 Answers Oracle,

How to view existing locks on the database?

Is a rollback possible to any savepoint?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1789)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)