Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South
and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't
make it this year, check out TidalScale at www.tidalscale.com. Be
sure to click on the Solutions link and look through the Oracle resources.
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;
/
