The oracle engine will execute the command,and retrives all the data from

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / gvprasad

Answer Posted / gvprasad

The oracle engine will execute the command,and retrives all
the data from the database and give it to the end user.

Is This Answer Correct ?

23 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How to assign sql query results to pl sql variables?

1146

What are local and global variables and their differences?

1140

What is the usage of nvl function?

1102

What is cursor status?

1237

Explain the commit statement.

1215

What is the difference between cluster and non-cluster index?

1158

Is it possible to read/write files to-and-from PL/SQL?

1151

What is the difference between inner join and natural join?

1057

How can you know that statistics should be updated?

1128

What is the current version of sql?

1069

What is the difference between having and a where in sql?

1151

what is the difference between where clause and having clause? : Sql dba

1045

What is scalar data type in pl sql?

1119

How do you explain an index?

1331

Why is partition used in sql?

1183