XML-Enabled Applications - Part 3

Monday Oct 1st 2007 by DatabaseJournal.com Staff

In this section we look at validating XML documents against XML schemas. Topics covered include: retrieving XML data, accessing relational data through XMLType views, using XMLType views and performing DML operations on XML schema-based XMLType views.

[From WebReference]

This is an excerpt from the book, PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax, by Yuli Vasiliev. Published by Packt Publishing Ltd., 2007

Retrieving XML Data

To retrieve XML data from an XMLType table, you can use a SELECT SQL statement, just as you would if you had to query a relational table. For example, to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section, you might issue the following query from SQL*Plus when connected as xmlusr/xmlusr:

The article continues at http://www.webreference.com/programming/php/xml-enabled-applications3/

Mobile Site | Full Site