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

Answer Posted / pradeep

select * from all_users;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of oracle?

560


How to add a new column to an existing table with a default value?

548


how to clone 9i Database on to 10g Database.

1828


What is a nested table?

631


What is a sub query? Describe its types?

549






What are the differences between blob and clob in oracle?

586


What are the most common interview questions on ETL Testing for experience?

597


How to install oracle odbc drivers?

624


What is oracle used for?

536


does the query needs a hint to access a materialized view?

1468


How to use in conditions in oracle?

561


Where is the export dump file located?

575


How to pass parameters to procedures?

555


What is oracle latest version?

587


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1460