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 the use of triggers?

541


How to select unique records from a table?

567


What are the two parts of design view?

579


Why is a trigger used?

521


what is heap table? : Sql dba

604






What is a constraint? Tell me about its various levels.

634


what is acid property in database? : Sql dba

557


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

552


Does sql use python?

559


Can I join the same table twice?

522


What is a stored procedure in sql with example?

598


Can a table contain multiple foreign key’s?

569


What is autocommit sql?

538


What is oracle pl sql developer?

530


How many sectors are in a partition?

557