Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25750 Views
- CG-VAK, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / paras jain
in fetch exit condition is must in for loop no need.
| Is This Answer Correct ? | 4 Yes | 0 No |
Is record in pl sql?
what are the limitations of identity column? : Transact sql
What do you mean by field in sql?
a procedure one in two out parameters i am waiting it in a sql query can i get the output
What are the parameter modes supported by pl/sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is normalisation and its types?
What are the built in functions of sql?
How do I run a sql trace?
Can we join tables without foreign key?
What is normalization? How many normalization forms are there?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
