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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to sort the rows in sql.

618


Can you select everything, but 1 or 2 fields, without writer's cramp?

513


What is procedure in pl sql?

544


Mention what plvcmt and plvrb does in pl/sql?

651


What packages(if any) has oracle provided for use by developers?

5051






what is a relationship and what are they? : Sql dba

561


Why having clause is used in sql?

559


What is the difference between instead of trigger and after trigger?

521


What can sql server reporting services do?

596


Describe types of sql statements?

556


how to use regular expression in pattern match conditions? : Sql dba

544


How many types of normalization are there?

502


who introduced sql?

582


Is record in oracle pl sql?

541


What are the parameter modes supported by pl/sql?

549