Using the Oracle XML Schema Definition XSD   Oracle Database 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 XML documents.

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
BEGIN
DBMS_XMLSchema.registerSchema(
schemaurl=>'http://marge:8080/home/DEV/xsd/message.xsd',
schemadoc=>sys.UriFactory.getUri('/home/DEV/xsd/message.xsd'));
END;
/

-- Delete XML schema
BEGIN
DBMS_XMLSchema.deleteSchema(
schemaurl=>'http://marge:8080/home/DEV/xsd/message.xsd',
delete_option=>DBMS_XMLSchema.Delete_Cascade_Force);
END;
/
 

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.