4 Replies Latest reply: May 18, 2012 4:22 AM by 937888 RSS

    How to fetch range of rows using cursor?

    926113
      There is a select query:

      SELECT * FROM t;

      How to fetch the range of rows from 300 to 500 using the cursor?

      DECLARE CURSOR mycursor IS SELECT * FROM t;
      BEGIN;
      OPEN mycursor;
      FETCH ...?
      CLOSE mycursor;
      END;