The UNDER_PATH condition is used to determine whether or not resources specified in a given column can be found under a particular path specified by path_string in the Oracle XML database repository.
The path information is computed by the RESOURCE_VIEW view, which you may query to use this condition.
UNDER_PATH lets applications search for resources that are contained (recursively) within a particular folder, get the resource depth, and so on.
SELECT PATH(1), DEPTH(2)
WHERE UNDER_PATH(resource, '/sys/schemas/OE', 1)=1
AND UNDER_PATH(resource, '/sys/schemas/OE', 2)=1;