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
3886 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 a View ?

what is the syntax of CREATE command?

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers Atos Origin,

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

Is there a function to split a string in plsql?

What are the differences between char and varchar2 in oracle?

How can we delete duplicate rows in a table?

What is a nvl function?

What is a nested table?

Explain the use of record option in exp command.

Why is oracle used?

What is difference between sid and service name in oracle?

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)