it will display all the records of emp table.

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

Question Posted / dinesh chandra

Answer Posted / dinesh chandra

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the types of exception?

1120

Explain implicit cursor.

999

How to pass parameters to procedures?

1014

How to specify default values in insert statement using oracle?

1083

What is ordinary table in oracle?

1131

How to loop through data rows in the implicit cursor?

1050

What are the ways tablespaces can be managed and how do they differ?

2339

How can you merge two tables in oracle?

968

What is a select query statement in oracle?

940

How to create an initialization parameter file?

1025

Define oracle database

1024

What is user managed backup in Oracle?

1118

How do I escape a reserved word in oracle?

1183

How does oracle handle read consistency?

1075

How to turn on or off recycle bin for the instance?

1049