O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CRITICAL SKILL 8.6

Create a Relational View from XML

Oracle XML DB makes it possible to expose XML content, stored in the database through conventional relational views. This means that tools, applications, and programmers who have no understanding of XML, but understand the Oracle Database 10g, can now work with XML content. To accomplish this, the view definitions use the SQL/XML functions and XPath expressions to map between the nodes in the XML document and the columns in the view.

Progress Check Answers

1. No, the Oracle XML DB is integrated with Oracle Database 10g.

2. The XML Schema defines the legal structure for an XML document. To confirm that the XML stored within the XMLType is “valid,” the URL for the XML Schema it is associated ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required