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
4321 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

How to convert times to characters in oracle?

What are a cluster and non-cluster index?

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers Oracle,

How to use "for" statements in oracle?

What are the general rules on data consistency?

How will you differentiate between varchar & varchar2?

What is the difference between pre-select and pre-query?

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

What is an Oracle index?

Find all employees in Dept “Marketing”.

How to enter a new row into a table interactively?

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1808)
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)