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

What is a table index in oracle?

846

What is partitioned table in Oracle?

840

How to connect to a local oracle 10g xe server?

722

How to install oracle database 10g xe?

774

What is a sub query? Describe its types?

770

What are the oracle differences between nvl and coalesce

782

What are data pump export and import modes?

818

How to create a table index in oracle?

859

How to start instance with a minimal initialization parameter file?

784

How to retrieve data from an cursor to a record?

754

What are the attributes of cursor?

783

Can we create database in oracle using command line ?

808

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

750

How to create a new user account in oracle?

784

is there a tool to trace queries, like profiler for sql server?

824