Database Reference
In-Depth Information
IS A SET implies that a collection is a set because it con-
tains unique values only.
<nested table> IS [NOT] A SET
IS EMPTY checks for an empty collection, a nested table
containing no elements whatsoever, essentially a collection not as
yet instantiated.
<nested table> IS [NOT] EMPTY
MEMBER OF attempts to validate membership within a
collection.
<expression> [NOT] MEMBER OF <nested table>
SUBMULTISET indicates if one or more collection items
are a subset of another collection.
<nested table> [NOT] SUBMULTISET [OF]
<nested table>
IS OF TYPE checks object datatypes.
<expression> IS [NOT] OF [TYPE].
Equality and inequality. Nested tables and VARRAY collec-
tions can be compared using equality (=) and inequality operators
(!=, <>).
REGEXP_LIKE utilizes regular expressions as opposed to sim-
ple pattern matching (see Chapter 14).
<regular expression> REGEXP_LIKE (<source>
, <pattern>, <match>)
The SPREADSHEET clause extends the SELECT statement
allowing for calculations between cells and rows (see Chapter 11).
IS ANY qualifies SPREADSHEET clause dimensional values.
<dimension> IS ANY
IS PRESENT ensures that a cell exists before the execution of a
SPREADSHEET clause.
<cell> IS PRESENT
