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

How do we create privileges in oracle?

1001

What is where clause in oracle?

994

Is oracle an open source?

1033

What is a dead lock in oracle?

1060

What is tns name?

934

Can select statements be used on views in oracle?

1000

What is the purpose of save points in oracle database?

1029

How to update values on multiple rows in oracle?

991

What is the relation of a user account and a schema in oracle?

1021

How to rename a column in an existing table?

986

What is key preserved table?

971

List out the difference between commit, rollback, and savepoint?

998

In the oracle version 9.3.0.5.0, what does each number shows?

1242

How to define an external table with a text file?

1029

Explain the use of grant option in exp command.

1020