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

Answer Posted / rahul vishwakarma

When we execute this command then the Oracle engine start
the process and terieve the values and store them in
IMPLICIT CURSOR then the values from this cursor are send
to the user panel

Is This Answer Correct ?    27 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are stored procedures faster than dynamic sql?

535


What is rowtype?

568


What is difference between cursor and trigger?

559


What is string join?

559


What are sql data types?

548






What are instead of triggers?

626


Is sql better than excel?

519


What is autocommit sql?

540


What is java sql package?

538


What port does sql server use?

510


what are the advantages of sql ? : Sql dba

550


How many sql core licenses do I need?

509


What has stored procedures in sql?

602


Define commit?

555


Is it possible to include an insert statement on the same table to which the trigger is assigned?

561