Quick Search:
 
 The Oracle PL/SQL PATH Function      [Return To Index] Jump to:  

Term: PATH

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:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org