Chapter 14

SQL and XML

EXtensible Markup Language (XML), a meta-markup language developed by the World Wide Web Consortium (W3C) in 1996, is widely used as a standard means of exchanging data over the Internet. XML uses HTML-like tags and attributes to structure data. Tags in XML allow developers to define data items and their relationships. Most relational database products, like Oracle, are now XML enabled. XML-enabled databases provide the capability to transfer data between XML documents and the data structures of a database.

This chapter is intended to be an introductory chapter of examples using SQL and XML. Our goal in this chapter is to introduce XML and illustrate a connection between XML and Oracle databases. The XML extension in Oracle ...

Get Practical Guide to using SQL in Oracle now with O’Reilly online learning.

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