what is the difference between cursor FETCH and FOR LOOP ?

Answer Posted / paras jain

in fetch exit condition is must in for loop no need.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database white box testing and black box testing?

634


Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3105


What is t-sql? : Transact sql

540


When is the explicit cursor used ?

588


Why is theta join required?

662






What is a clob in sql?

565


How is pl sql different from sql?

545


What is snowflake sql?

580


Can we use ddl statements in stored procedure sql server?

517


Write a sql query to get the third highest salary of an employee from employee_table?

634


what is sub-query? : Transact sql

596


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

502


How do you remove duplicates without using distinct in sql?

499


What are the string functions in sql?

528


Can 2 queries be executed simultaneously in a distributed database system?

642