If there is no such row, an empty result is returned, and the cursor is left positioned before the first row or after the last row as appropriate. The forms NEXT, PRIOR, FIRST, LAST, ABSOLUTE, RELATIVE fetch a single row after moving the cursor appropriately. FETCH ALL or FETCH BACKWARD ALL will always leave the cursor positioned after the last row or before the first row. If FETCH runs off the end of the available rows then the cursor is left positioned after the last row, or before the first row if fetching backward. After fetching some rows, the cursor is positioned on the row most recently retrieved. When created, a cursor is positioned before the first row. The cursor position can be before the first row of the query result, on any particular row of the result, or after the last row of the result. FETCH retrieves rows using a previously-created cursor.Ī cursor has an associated position, which is used by FETCH.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |