XML Schema Designer

The XML Schema Designer lets you create XML schemas. For more information on XML schemas, see Oracle XML DB Developer's Guide.

This section covers the following topics:

Starting the XML Schema Designer

In Server Explorer, right-click the XML Schemas node and from the menu, select New XML Schema.

The XML Schema Designer appears as follows:

Using the XML Schema Designer

In general, to use the XML Schema Designer, you specify the schema's URL, its scope, and the file containing the schema's text.

The XML Schema Designer has the following controls:

Control Description

Schema URL

Enter the name of the schema in standard URL format, for example:

http://xmls.mycompany.com/myfile.xsd

Scope

Select from the following:

  • Local: Sets the schema to be visible only to the user creating it.

  • Global: Sets the schema to be visible to the public.

Specify the file that contains the schema text

In the File box, specify the file name or click Browse to search for the file in the local file system.

Use for Binary XML Storage

Registers the XML Schema to be used for binary XML storage.

XMLType tables or columns that need to store a schema-based XMLType as binary XML must use an XML Schema registered for binary XML storage. XML Schemas registered for binary XML storage cannot be used to create schema-based XMLType table or columns with Object relational storage. Binary XML is available in Oracle Database version 11.2.0.1 or later.

Preview SQL

Displays the SQL that will be executed when OK is clicked.

OK

Creates the XML Schema and closes the dialog.

Cancel

Closes the dialog without creating the XML Schema.

Help

Opens this help page.

See Also

XML Schemas Node