what is the difference between cursor FETCH and FOR LOOP ?

Answer Posted / meher

The main difference between cursor FETCH and FOR LOOP is as
below :
In case of cursor FETCH the cursor will open atleast once
but in case of cursor FOR LOOP the cursor will may or
maynot be open.

Is This Answer Correct ?    31 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you improve the performance of sql*loader? : aql loader

580


What is the difference between functions, procedures, and packages in pl/sql?

482


What is the difference between microsoft access and sql server?

533


Can I join the same table twice?

524


what are ddl statements in mysql? : Sql dba

579






What is mutating error in pl sql?

550


What is foreign key in sql with example?

515


What is a temp table?

568


What is indexes?

542


Mention what are different methods to trace the pl/sql code?

560


What is pl sql in dbms?

507


How many disk partitions should I have?

551


Is sql microsoft?

547


What is a loop in sql?

567


What happens when a trigger is associated to a view?

502