Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between cursor FETCH and FOR LOOP ?

Question Posted / lmeher.tcs

Answers were Sorted based on User's Feedback



what is the difference between cursor FETCH and FOR LOOP ?..

Answer / 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

what is the difference between cursor FETCH and FOR LOOP ?..

Answer / kiran kumar

The cursor FOR LOOP implicitly declare loop index as a
record of %ROWTYPE open a cursor implicity and repeatedly
fetch the records from the active set into the field of
record, then close the cursor implictly all rows have been
processed.
In case of cursor FETCH explicity open a cursor, fetch the
records and close the cursor.

Is This Answer Correct ?    26 Yes 3 No

what is the difference between cursor FETCH and FOR LOOP ?..

Answer / paras jain

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

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a database? Explain

0 Answers  

Can you alter start with clause?

1 Answers   TCS,

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

What are the different type of joins in sql?

0 Answers  

what is the use of double ampersand (&&) in sql queries?

0 Answers  

What is nested table in pl sql?

0 Answers  

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

Why is partition used in sql?

0 Answers  

What is the maximum number of columns in sql table?

0 Answers  

How does stored procedure reduce network traffic?

0 Answers  

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

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories