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
What is the use of oracle?
How to add a new column to an existing table with a default value?
how to clone 9i Database on to 10g Database.
What is a nested table?
What is a sub query? Describe its types?
What are the differences between blob and clob in oracle?
What are the most common interview questions on ETL Testing for experience?
How to install oracle odbc drivers?
What is oracle used for?
does the query needs a hint to access a materialized view?
How to use in conditions in oracle?
Where is the export dump file located?
How to pass parameters to procedures?
What is oracle latest version?
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?