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

Creator

  • PWH617
  •  (Gold) 1905 points
  • 100% positive feedback
© 2024 CSOFT International, Ltd.