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

Answer Posted / a.swarna devi

select * from user_tables;

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign query results to variables?

584


Can we insert data in view oracle?

529


How to get the Installed Oracle Version Information ?

612


What is a select query statement in oracle?

539


What is coalesce function?

565






How to define a specific record type?

609


How to create a temporary table in oracle?

682


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1522


Explain what are the uses of rollback segment?

574


Can we store pictures in the database and if so, how it can be done?

580


Explain how you would restore a database using RMAN to Point in Time?

1622


What are the roles of dba?

606


Why do we need oracle client?

505


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1822


What is an oracle function?

587