Object-Relational XMLType

Creating object-relational (O-R) XMLTypes starts from the XML Schema registration. The XML registration process not only registers the XML Schema to Oracle XML DB, but also creates object-relational tables. The O-R table creation is based on the default setup in Oracle XML DB and the Oracle XML DB XML Schema annotations.

Image

FIGURE 12-2. Annotating XML schemas in Oracle JDeveloper 11g

Figure 12-2 shows how you get in-line hints when adding XML DB annotations in Oracle JDeveloper 11g. The following is an example of an annotated XML schema (contact_annotated.xsd):

Listing 12-1 Annotating XML Schemas for O-R XMLType Storage ...

Get Oracle Database 11g Building Oracle XML DB Applications 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.