Database Reference
In-Depth Information
Figure 7.6
The IS NULL
Comparison
Condition.
SELECT COUNT(*) FROM SONG
WHERE PLAYING_TIME IS NOT NULL;
XML conditions are EQUALS_PATH and UNDER_PATH.
EQUALS_PATH searches the entire path from the root node of an
XML object and UNDER_PATH a relative path. A relative path
begins at a specified node in an XML structure.
EQUALS_PATH (<column>, <path>) = <expression>
UNDER_PATH (<column> [, levels], <path>)
= <expression>
See Chapter 17 for more detail on using XML in Oracle SQL.
Object collection conditions are as follows (see Chapter 16 for more
detail on nested tables):
