Creating and Dropping XML Tables

Last modified: October 23, 2019

Creating an XML Table

1. Click the New Database Object button on the Standard toolbar and specify an object type.

2. Select the XML Table type in the dialog box.

   Note

   If there is no such menu command, this instance of the Oracle server does not support XML objects, and you can not create XML table on it.

3. Input the table name.
4. Specify the owner of the XML schema, choose the schema to contain the object being created, the source XML schema and the element to be stored in the table.
5. You can also specify storing options of the table.
6. Click the Create button. If specified name is unique the table will appear in Database Explorer.

Deleting an XML Schema

1. In the Database Explorer window, expand the XML Schemas folder.
2. Right-click a required schema, and then click Delete on the shortcut menu.
3. Click Yes in the appeared dialog box.

Note

When you drop a table all data containing in it is lost.