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

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