WHAT HAPPENS WHEN YOU SAY OPEN CURSOR?

Varun Agrawal

Total Post:159

Points:795
Posted by  Varun Agrawal
DB2 
DB2
 1245  View(s)
Ratings:
Rate this:
  1. Varun Agrawal

    Post:159

    Points:795
    What happens when you say OPEN CURSOR?

    If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!