Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
path::=
PATH
is an ancillary function used only with the UNDER_PATH
and 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.
See Also:
|
The EQUALS_PATH
and 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").
SELECT PATH(1), DEPTH(2) FROM RESOURCE_VIEW WHERE UNDER_PATH(res, '/sys/schemas/OE', 1)=1 AND UNDER_PATH(res, '/sys/schemas/OE', 2)=1; PATH(1) DEPTH(2) -------------------------------- -------- /www.oracle.com 1 /www.oracle.com/xwarehouses.xsd 2