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 load excel data sheet to oracle database

588

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1804

What are the system predefined user roles?

587

Give syntax for SQL and ORACLE joins.

636

What is partitioned table in Oracle?

639

When do you get a .pll extension in oracle? Explain its importance

575

Can a parameter be passed to a cursor?

600

How to export your connection information to a file?

598

Describe varray?

592

Explain user account with reference to oracle.

538

What is the use of file param in imp command?

646

What is the maximum number of triggers that can be applied to a single table?

561

Can you tell me how to add new column in existing views?how?How is possible?

942

what are archived logs?

1717

How to create a stored procedure in oracle?

577