|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 90 of 177
PATH is an ancillary function used only with the
EQUALS_PATH conditions. It returns the relative path that leads to the resource specified in the parent condition.
The correlation number can be any number and is used to correlate this ancillary function with its primary condition. Values less than 1 are treated as 1.
UNDER_PATH conditions can take two ancillary functions, one of which is
PATH. The following example shows the use of both ancillary functions. The example assumes the existence of the XMLSchema
warehouses.xsd (created in "Using XML in SQL Statements").