Functions, 90 of 177

PATH

Syntax

path::=

Text description of functions172b.gif follows

Purpose

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:

EQUALS_PATH UNDER_PATH
the related function DEPTH

Examples

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