Advanced XQuery

  • Using XQuery to Generate XML

  • Using XQuery to Transform XML

  • Using XQuery For Querying XML

  • XQuery Support in SQL*Plus

  • Using XQuery with PL/SQL: Binding Dynamic Variables

  • Using Namespace with XQuery

Manipulating and Generating XML Data

  • Using SQL functions to update XML data


  • Generating XML using new SQL/XML functions

  • Generating XML using DBMS_XMLGEN package

Understanding and Optimizing XPath and XQuery Rewrite

  • Overview of XPath Rewrite

  • XPath rewrite benefits

  • Instances where XPath rewrite occur and does not occur

  • XPath rewrite process

  • Detecting XPath Rewrite

  • XPath rewrite of SQL Functions

  • XQuery Rewrite

  • Tuning the performance of XQuery Expressions


  • Introducing PL/SQL APIs for XMLType

  • Document Object Model(DOM)

  • Using DBMS_XMLDOM to create a DOM document.

  • Using DBMS_XMLPARSER to access the contents and structure of XML documents

  • Using DBMS_XSLPROCESSOR for transforming an XML documents

Importing/Exporting XML Data

  • Loading XMLType data using SQL*Loader

  • Importing and exporting XMLType data

  • Creating XMLType Queue

  • Enqueue and dequeue XML messages

More Details

Total Views:8
Reference Id:#499090
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]