O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

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

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