XML Database Node
This section covers the following topics:
About XML Databases
Oracle XML Database is an extension to Oracle Database. It allows faster retrieval and search capabilities, access control, and versioning of XML documents. In addition, it provides SQL access to the same XML data. The XML instance documents saved in the database must conform to an XML schema.
For more information about Oracle XML databases, see Oracle XML DB Developer's Guide.
How the XML Database Node Works
The XML Database node contains all XML-related nodes in Server Explorer. It has one child node, the XML Schemas node, which in turn can have one or more child XML Schema nodes.
To perform actions on the XML Database 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.
Menu Options
| Menu Option | Description |
|---|---|
|
Query Window |
Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio. |
|
Refresh |
Updates the XML Database node tree, including its associated XML Schema nodes. If the database object associated with the node was deleted from the database, you will be asked if the node needs to be deleted from the Server Explorer. |
|
Properties |
Displays the Properties window. |
See Also