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

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Question Posted / saiprasannach89

2 Answers
4988 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

wirte the syntax of update query?

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers Microsoft, Wipro,

How to upsert (update or insert into a table)?

What is set operator oracle?

What is varray?

Without giving condition how to retrieve the unmatched records from table.

Explain the types of exception?

What is a procedure in oracle?

1) Does oracle have any table which contain all the exceptions and it's code internally?

How are Indexes Update ?

What is the data type of dual table?

What WHERE CURRENT OF clause does in a cursor?

For more Oracle General Interview Questions Click Here

Categories

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