|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Conditions, 12 of 13
UNDER_PATH condition determines whether resources specified in a 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 query to use this condition.
Use this condition in queries to
PATH_VIEW. These public views provide a mechanism for SQL access to data stored in the XML database repository.
RESOURCE_VIEW contains one row for each resource in the repository, and
PATH_VIEW contains one row for each unique path in the repository.
levels argument indicates the number of levels down from
path_string Oracle should search. Oracle treats values less than 0 as 0.
correlation_integer argument correlates the
UNDER_PATH condition with its ancillary functions
RESOURCE_VIEW computes the paths (in the
any_path column) that lead to all XML resources (in the
res column) in the database repository. The following example queries the
RESOURCE_VIEW view to find the paths to the resources in the sample schema
oe. The query returns the path of the XML schema that was created in "XMLType Table Examples":