Re: XML parsing using PL/SQL

Try the oreilly book - Building Oracle XML Applications, ISBN: 1565926919; Look at chapter 5
Here a table of contents for the book.
Building Oracle XML Applications
Table of Contents
Preface

 I. XML Basics

1. Introduction to XML What Is XML? What Can I Do with XML? Why Should I Use XML? What XML Technologies Does Oracle Provide?
2. Working with XML Creating and Validating XML Modularizing XML Searching XML with XPath

 II. Oracle XML Fundamentals

3. Combining XML and Oracle

      Hosting the XML FAQ System on Oracle
      Serving XML in Any Format
      Acquiring Web-based XML Content

4. Using JDeveloper for XML Development
      Working with XML, XSQL, and JSP Files
      Working with Database Objects
      Using JDeveloper with Oracle XDK Components

5. Processing XML with PL/SQL
      Loading External XML Files
      Parsing XML
      Searching XML Documents with XPath
      Working with XML Messages
      Producing and Transforming XML Query Results

6. Processing XML with Java
      Introduction to Oracle8i JServer
      Parsing and Programmatically Constructing XML
      Searching XML Documents with XPath
      Working with XML Messages
      Producing and Transforming XML Query Results

7. Transforming XML with XSLT
      XSLT Processing Mechanics
      Single-Template Stylesheets
      Understanding Input and Output Options
      Improving Flexibility with Multiple Templates

8. Publishing Data with XSQL Pages
      Introduction to XSQL Pages
      Transforming XSQL Page Results with XSLT
      Troubleshooting Your XSQL Pages

9. XSLT Beyond the Basics
      Using XSLT Variables
      The Talented Identity Transformation
      Grouping Repeating Data Using SQL
      Sorting and Grouping Repeating Data with XSLT

10. Generating Datagrams with PL/SQL
      Programmatically Generating XML Using PL/SQL
      Automatic XML Generation with DBXML

11. Generating Datagrams with Java
      Generating XML Using Java
      Serving XML Datagrams over the Web
      Automatic XML from SQL Queries

12. Storing XML Datagrams
      Overview of XML Storage Approaches
      Loading Datagrams with the XML SQL Utility
      Storing Posted XML Using XSQL Servlet
      Inserting Datagrams Using Java

13. Searching XML with interMedia
      Why Use interMedia?
      What Is interMedia?
      The interMedia Query Language
      Handling Heterogeneous Doctypes
      Handling Doctype Evolution
      Advanced interMedia

14. Advanced XML Loading Techniques
      Storing Datagrams in Multiple Tables
      Building an XMLLoader Utility
      Creating Insert Transformations Automatically

 III. Oracle XML Applications

1. Using XSQL Pages as a Publishing Framework Overview of XSQL Pages Facilities Additional XML Delivery Options
2. Extending XSQL and XSLT with Java Developing Custom XSQL Actions Integrating Custom XML Sources Working with XSLT Extension Functions
3. XSLT-Powered Portals and Applications XSLT-Powered Web Store Building a Personalized News Portal Online Discussion Forum

 IV. Appendixes

1. XML Helper Packages
2. Installing the Oracle XSQL Servlet
3. Conceptual Map to the XML Family
4. Quick References
   • Michael Robinson robinsonm_at_rockymountainnews.com

"Neil Barton" <nbarton_at_dpapplications.com> wrote in message news:paoL5.2062$34.49303_at_e420r-sjo3.usenetserver.com...
> We have data that is stored in XML format in a series of rows that can be
> pieced together to represent the entire XML document, in a CLOB data type.
> We are not currently using the Context Option from Oracle. What we want to
> do is be able to parse the XML document looking for specific columns and
> values without requiring the Context options. Has anyone ever done this
> before in PL/SQL?
>
> TIA
>
>
>
>
>
>
Received on Tue Oct 31 2000 - 09:24:29 CET