Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between cursor FETCH and FOR LOOP ?
- 3 Answers
- 25743 Views
- CG-VAK, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How is a PL/SQL code compiled?
What is int identity in sql?
Can dml statements be used in pl/sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
How many types of indexes are there in sql?
What is the difference between null value, zero, and blank space?
What is primary key and foreign key with example?
What is rename command in sql?
Which join is like an inner join?
What are sql data types?
Is sql port 1433 encrypted?
What is the difference between stored procedure and view?
Can we enter data in a table in design view?
Which certification is best for sql?
What are the parts of a basic sql query?
