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 turn on or off recycle bin for the session?

1102

What is an oracle tablespace?

1032

What do you mean by cdb and pdb in oracle 12c?

1055

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

987

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2098

What is a view and how is it different from a table?

1036

Explain the use of owner option in exp command.

1037

candidate key is subset of super key but not vice-verse explain

2064

Explain the different normalization forms?

1070

Explain alias?

1121

How will you write a query to get a 5th rank student from a table student_report?

1856

Design database draw er diagram for a certain scenario ?

4575

How to store only time; not date and time?

1015

What happens in oracle commit?

1017