Home >  Term: Update hole
Update hole

(1) A row for a SELECT statement of a cursor that no longer has a corresponding row in the base table because the row was updated. An update hole is created when a row in the base table is updated such that the row no longer qualifies to be in the result set while a cursor is open whose SELECT statement result contains the row that is updated. Such a row is no longer accessible though the cursor. See also delete hole.
(2) The location on which a cursor is positioned when a row in a result table is fetched again and the new values no longer satisfy the search condition. See also delete hole.

0 0

Kūrėjas

  • Harry8L
  • (London, United Kingdom)

  •  (V.I.P) 574128 points
  • 100% positive feedback
© 2026 CSOFT International, Ltd.