17

XML in Oracle

In this chapter:

  • What is XML?

  • What is XSL?

  • What are the different XML generation methods for Oracle SQL?

  • How do we create XML objects from database tables?

  • How can XML document objects stored in the database be viewed and altered?

As in many modern databases, there is immense capability in Oracle SQL for utilizing the power of XML. This chapter only covers XML as directly related to Oracle SQL. In other words, we examine how XML documents can be created, accessed, and manipulated directly from within Oracle SQL. To begin with, let’s briefly summarize exactly what XML is. To accomplish this, we have to start at the root of browser scripting languages, HTML. So what is XML?

17.1 What Is XML?

Hypertext Markup Language (HTML) is ...

Get Oracle SQL 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.