Using the Oracle XML Schema Definition XSD
Oracle Tips by Burleson Consulting
Question: How does the XML Schema Definition (XSD)
component work within Oracle?
Answer: The XSD (XML Schema
Definition), is a database metadata generic Document Type Definition (DTD) that
allows you to store XML documents. Once you define a document structured with a
DTD, you can load it into the XSD schema and use it to validate the structure of
You can see the standard XSD XML DTD elements
here. I've not used XSD, but Dr.
Hall has some notes:
The basic_message.xsd XML schema defines the structure of the XML message
documents we are trying to store. For this example we will use the
message.xsd XML schema which contains some additional annotations that
affect the way XML DB functions.
Save the message.xsd XML schema on your filesystem and copy it to the
"/home/DEV/xsd/" folder in the XML DB repository (See Connecting To XML DB).
At this point the XML schema has stored within the XML DB repository. To
make XML DB aware of the XML schema it must be registered:
-- Register XML schema
-- Delete XML schema
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts.