1. SQL Reference Guide
  2. Data Row Management
  3. UPDATE Statement
  4. Update Clauses
  5. REMOVE Clause

REMOVE Clause

Syntax

remove_clause ::= path_expression

Semantics

The remove clause consists of a single target expression, which computes the items to be removed. The REMOVE clause iterates over the target items. For each such item, if its parent is a record, an error is raised. Otherwise, if the target item is not NULL, it is removed from its parent. If the target item is NULL, then since arrays and map cannot contain NULLs, one of its ancestors must be NULL. In this case, the NULL is skipped.

See Example: Updating Rows.