Cursors

• Can declare a cursor on a relation or query statement (which generates a relation).

• Can open a cursor, and repeatedly fetch a tuple then move the cursor, until all tuples have been retrieved.

  • Can use ORDER BY to control the order in which tuples are returned.
    • Fields in ORDER BY clause must also appear in SELECT clause.

• Can also modify/delete tuple pointed to by a cursor.

Previous slide

Next slide

Back to first slide

View graphic version