Oracle DBMS_XQUERY
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Database support for XQuery
AUTHID CURRENT_USER
Dependencies
XMLTYPE    
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/initxqry.sql
 
EVAL
Undocumented dbms_xquery.eval(xqry IN VARCHAR2) RETURN XMLTYPE;
conn uwclass/uwclass@pdbdev

set serveroutput on

DECLARE
 inval VARCHAR2(200) := '''FOR $i IN /PDRecord where $i /PDName = "Daniel Morgan" ORDER BY $i/PDName return $i/PDName'' PASSING BY VALUE person_data';
 retval XMLTYPE;
BEGIN
  retval := dbms_xquery.eval(inval);
END;
/

DECLARE
 inval  VARCHAR2(200) := 'FOR $i IN /PDRecord where $i /PDName = "Daniel Morgan" ORDER BY  $i/PDName return $i/PDName';
 retval XMLTYPE;
BEGIN
  retval := dbms_xquery.eval(inval);
END;
/

Related Topics
Built-in Functions
Built-in Packages
DBMS_XQUERYINT
What's New In 18c
What's New In 19c
XMLQUERY

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx