Chapter 2

Storing XML Data in SQL Tables


Bullet Adding XML data to an SQL pseudotable

Bullet Designing tables to store XML data

Bullet Bringing XML documents current

Bullet Getting to know Oracle’s tools for updating tables with XML

Bullet Discovering Microsoft’s tools for updating tables with XML

The latest version of the ISO/IEC SQL specification (SQL:2016) details how to store XML data in an SQL-compliant database and operate on it with SQL. In this chapter, I cover SQL’s basic data manipulation operations as applied to XML data. Because the primary focus of this book is SQL, I assume that you’re already up to speed on XML.

Inserting XML Data into an SQL Pseudotable

Until recently, with regard to the relationship between SQL and XML, the emphasis has been on converting SQL table data to XML to make it accessible on the Internet. A more recent addition to the SQL standard addresses the complementary problem of converting XML data to SQL tables so that it can be easily queried using standard SQL ...

Get SQL All-In-One For Dummies, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.