“Cursor” is a symbolic name associated with a select statement. A cursor consists of the following parts:
Cursor result set – the set (table) of qualifying rows that result from the execution of a query associated with the cursor.
Cursor position – a pointer to a row within the cursor result set.
The cursor position indicates the current row of the cursor. With an updatable cursor, you can explicitly modify or delete that row using update or delete statements, with a clause naming the cursor.
Two attributes specify the cursor’s behavior:
sensitivity
scrollability
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
