Quick Search:
 
 The Oracle UNDER_PATH Condition      [Return To Index] Jump to:  

Term: UNDER_PATH

Definition:
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.

Example Usage:

SELECT PATH(1), DEPTH(2)
FROM RESOURCE_VIEW
WHERE UNDER_PATH(resource, '/sys/schemas/OE', 1)=1
AND UNDER_PATH(resource, '/sys/schemas/OE', 2)=1;


Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org