O'Reilly logo

Oracle Database 11g: Building Oracle XML DB Applications by Jinyu Wang

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

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

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