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.5

Use Simple Queries

The first thing you might do as a relational developer after finding out that XML data can be loaded into an Oracle Database 10g is some querying. Is querying different with this XML data? Are the queries ordinary SQL? Because Oracle XML DB is fundamentally based on the Oracle Database 10g relational architecture, the familiar SQL paradigm continues to work well in this new world.

The first thing to realize is that, to query documents in Oracle XML DB, you use SQL with some functional extensions. Here are a handful of SQL functions that use XPath notations and are part of a set of extensions to SQL that Oracle has implemented in Oracle Database 10g:

The existsnode () function is used in the where clause ...

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