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

Is java required for oracle client?

1002

What is oracle instant client?

1028

What is private procedure oracle?

1014

What is a subquery?

1127

What is a nested table?

1069

Explain the use of owner option in exp command.

1048

How to convert raw data type into text in oracle? Explain

995

What is merge in oracle?

1057

Explain what are the uses of rollback segment?

1017

How to create a new table in oracle?

1161

What is a system tablespace and when it is created?

975

What are a query and state the different types of queries and their uses?

1019

What is pragma autonomous transaction in oracle?

1074

Explain the importance of .pll extension in oracle?

1013

Design database draw er diagram for a certain scenario ?

4580