select * from dba

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

Question Posted / phan wai keong

Answer Posted / phan wai keong

select * from dba_users;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is better Oracle or MS SQL? Why?

6263

Explain the dml?

919

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1955

How to delete a column in an existing table?

1018

List the parts of a database trigger.

988

what is the difference between data migration and production migration.

2275

What do you understand by a database object? Can you list a few of them?

970

How to do paging with oracle?

948

What is a trigger and what are its types in oracle?

998

Are truncate and delete commands same? If so why?

1079

What happens to the current transaction if a ddl statement is executed?

950

What is a user account in oracle?

1065

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

What is ADDM Advisor in Oracle?

1115

candidate key is subset of super key but not vice-verse explain

2015