select * from user

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

Question Posted / a.swarna devi

Answer Posted / a.swarna devi

select * from user_tables;

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

WHAT IS ecc 6.0

1943

What is save point in oracle database?

1038

How do we create privileges in oracle?

832

Explain the use of grant option in exp command.

803

What is a trigger and what are its types?

841

What is the difference between sharding and partitioning?

775

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

847

What are temporal data types in oracle?

889

What are the differences between char and varchar2 in oracle?

849

Explain the use of control file?

895

How to define a variable to match a table column data type?

790

What is meant by a deadlock situation?

846

How to insert a new row into a table in oracle?

881

In the oracle version 9.3.0.5.0, what does each number shows?

1068

interview questions with answer for cts

2366