Thus, data modifications (insert, update, delete operations) from other transactions could have an impact on the result set.

In this scenario, a cursor enables the rows in a result set to be processed sequentially.

To evaluate a continuous query, one can simply reevaluate the query over newly arrived tuples, and append the new tuples to the existing result set.

With more than one table, the result set will be every combination of rows.

The target position for a scrollable cursor can be specified relatively (from the current cursor position) or absolutely (from the beginning of the result set).