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.
PATH (correlation integer)
The minimum value of the correlation integer is 1.
This example uses SQL function path to retrieve the relative paths under path /a/b.
WHERE UNDER_PATH(RES, '/Oracle/Accounts', 1) = 1;
2 rows selected.