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 ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
