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

How to convert characters to numbers in oracle?

1065

How do I limit the number of rows returned by an oracle query after ordering?

1168

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

What is recovery manager(rman) backup in Oracle?

1183

How to write a left outer join with the where clause in oracle?

1084

What is coalesce function?

1068

What is meant by joins? List out the types of joins.

1030

What is an Oracle Instance?

1121

What is flashback in Oracle?

1017

How do I start tns listener?

1042

State the various uses of dbcc command?

1060

Explain alias?

1147

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1882

what is insert all statement in sql

6513

material view and view disadvantages?

1073