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

11. Display the client number and name and the client number and name of the person who referred that client.

2329

How to load a large xml file?

1044

What is the difference between post-database commit and post-form commit?

1178

What are the attributes of cursor?

1044

What are the advantages of oracle 12c?

1174

Differentiate between pre-select and pre-query?

1099

What would you do with an in-doubt distributed transaction?

1972

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2818

What is bulk copy or bcp in oracle?

1113

How to write a query with an inner join in oracle?

1031

Explain enable novalidate constraint.

1071

How to start a new transaction in oracle?

1077

Please explain compound trigger in oracle?

1051

What privilege is needed for a user to create views in oracle?

1033

what is the difference between functional dependecy and multilevel dependency?

2452