select * from all

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

Question Posted / pradeep

Answer Posted / pradeep

select * from all_users;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

How to store only time; not date and time?

957

Explain about integrity constraint?

1076

what is the difference between restoring and recovering?

961

What happens if you set the sga too low in oracle?

1051

What is the difference between a hot backup and a cold backup in oracle?

954

What privilege is needed for a user to connect to oracle server?

938

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2243

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

949

What is a read write transaction in oracle?

1030

What happens if the imported table already exists?

970

How do I uninstall oracle 11g?

1038

Explain what are the characteristics of data files?

1029

Can I create users through internet explorer in oracle 10g?

1016

What are the uses of synonyms?

1080