Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle UNDER_PATH Condition      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 86 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?