Filter
Top Products
[Figure: Deriving a cursor table]
Sequence of rows fetched using a cursor
Note that the sequence of rows fetched using a cursor was not specified. Although the query expression specifies the
rows to be included in the cursor table, the query expression does not specify the sequence of fetching the rows. This
is true even for a simple cursor that fetches all rows of a table. The rows in the cursor table shown in Figure: Deriving
a cursor table are sometimes arranged in ITMNO sequence. However, when an application program is actually
executed, the sequence of rows may be as shown in Figure: Example of rows in a cursor table when the sequence is
undefined.
45