1.display list of all users from ur data base.what is the query?

1.display list of all users from ur data base.what is the
query?

Question Posted / oracle.siva1986

3 Answers
7831 Views
CGI, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1.display list of all users from ur data base.what is the query?..

Answer / nivitha

select * from dba_users order by desc;

Is This Answer Correct ?

18 Yes

5 No

1.display list of all users from ur data base.what is the query?..

Answer / srinivas

select * from all_users;

Is This Answer Correct ?

5 Yes

0 No

1.display list of all users from ur data base.what is the query?..

Answer / a.swarna devi

select * from user_tables;

Is This Answer Correct ?

0 Yes

8 No

Post New Answer

More Oracle General Interview Questions

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

0 Answers

what are the advantages of running a database in NO archive log mode?

1 Answers

What WHERE CURRENT OF clause does in a cursor?

2 Answers

what is the syntax of DROP command?

10 Answers

What is catalog in Oracle?

0 Answers MCN Solutions,

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers eicc,

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers BOB Technologies, Cap Gemini, IBM,

what is the difference between primary key & foreign key?

57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,

What is Network Database link ?

1 Answers

please explain.. DB architecture ...

0 Answers

what happened to the global index when I truncate the data in one of the partition?

0 Answers

What are the different type of Segments ?

2 Answers

For more Oracle General Interview Questions Click Here