| Home | Previous Lesson: The DELETE Statement Next Lesson: Declaring And Executing a Cursor |
Till now, in the embedded SELECT statements, we were able to retrieve only one row. Cursors are useful to retrieve more than one result row, and it allows you to process one row at a time. Similar to the cursor on a computer screen, a cursor indicates the position in the result set. The cursor points to a single row of data and can only scroll forward, one row at a time. In other words, an application can retrieve one single row, or move through the result set, one row at a time.
| Home | Previous Lesson: The DELETE Statement Next Lesson: Declaring And Executing a Cursor |