XML Schemas Node
This section covers the following topics:
About XML Schemas
An XML schema is written in a schema definition language in XML that describes the structure and other semantics of a conforming instance document. You must register the XML schema in an Oracle XML database before you can use the Oracle XML database. Before you register the XML schema, you must know the following:
-
Whether the data for the XML instance documents already exists in relational tables. If this is the case, you must create Object Views for XML.
-
Whether the storage model is LOB or Object Relational. This depends on which parts of the document are queried often and thus will need faster retrieval.
-
Whether the XML schema document is annotated with comments to generate object data types and object tables. If not, you must create and manually map these objects to the XML schema. If the XML schema is already annotated with information to automatically generate object types and object tables, the XML database automatically generates these objects and you can insert conforming XML documents into it.
Use the XML schema to create complex types and storage elements for XML documents based on the XML schema. This type is available for Oracle version 9.2 and above.
For more information about XML schemas and Oracle XML databases, see Oracle XML DB Developer's Guide.
How the XML Schemas Node Works
The XML Schemas node, which is the only child of the XML Database node, contains one or more child XML Schema nodes. To perform actions on the XML Schemas node: right-click this node and from the menu choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.
If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.
Menu Options
Menu Option | Description |
---|---|
New XML Schema |
Creates a new XML Schema in the XML Schema Designer. |
Query Window |
Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio. |
Filters |
Opens the Filters Tab to control which child nodes appear under the collection. |
Refresh |
Updates the Schemas node tree, including its associated schema nodes. |
Properties |
Displays the Properties window. |
See Also