Definition:
In Oracle PL/SQL, PATH is an ancillary function which takes a numeric input and returns a relative path to the resource specified in the parent condition. The input is used to correlate it to its primary condition. The function can be used only with the EQUALS_PATH and UNDER_PATH conditional functions for XML to determine whether an XML resource resides in the given path.
Example Syntax:
PATH (correlation integer)
The minimum value of the correlation integer is 1.
Example Usage:
This example uses SQL function path to retrieve the relative paths under path /a/b.
SELECT PATH(1)
FROM RESOURCE_VIEW
WHERE UNDER_PATH(RES, '/Oracle/Accounts', 1) = 1;
PATH(1)
-------
Scott
HR
2 rows selected.
Related Links:
