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

What is a user role in oracle?

1182

Which environment variables are absolutely critical in order to run the OUI?

2169

Please explain joins in oracle?

1103

In which language oracle has been developed?

1134

What is the usage of control file in oracle?

1141

What is ceil and floor in oracle?

1118

What is catalog in Oracle?

1431

How to recover a dropped table in oracle?

1092

How to define default values for formal parameters?

1091

What do you mean by merge in oracle and how can we merge two tables?

1094

What are the general rules on data consistency?

1055

How to rename a column in an existing table?

1081

Explain the difference between sap and oracle?

1081

How to initialize variables with default values?

1303

How to convert raw data type into text in oracle? Explain

1046