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

What is a loop in sql?

737


What is foreign key and example?

702


What types of commands can be executed in sql*plus?

760


What is denormalization in a database?

782


What is graph sql?

716






Is it possible to link two groups inside a cross products after the cross products group has been created?

765


Is pl sql still used?

680


What is the difference between nested table and varray?

681


What is attribute indicator in pl sql?

712


What are different types of functions in sql?

716


What is the use of & in pl sql?

720


What is server name sql?

798


Why do we create stored procedures & functions in pl/sql and how are they different?

692


What are the different types of a subquery?

711


What is difference between my sql and sql?

714