select * from emp
what happened internally when we write this query in the sql
prompt?

Answer Posted / dinesh chandra

it will display all the records of emp table.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the sid in oracle?

538


What is raw datatype in oracle?

585


What is meant by joins? List out the types of joins.

528


Whats the benefit of dbms_stats over analyze?

1497


How to define a cusotmer as a supplier in ORACLE R12

1728






What is dual table oracle?

527


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

594


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1812


What are temporal data types in oracle?

602


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1509


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

548


What is a dead lock in oracle?

598


How to check your oracle database 10g xe installation?

581


What is oracle sid?

509


How to insert multiple rows with one insert statement in oracle?

574