3.148 ALL_XML_SCHEMA_COMPLEX_TYPES

ALL_XML_SCHEMA_COMPLEX_TYPES describes all complex types accessible to the current user.

Related Views

• DBA_XML_SCHEMA_COMPLEX_TYPES describes all complex types in the database.

• USER_XML_SCHEMA_COMPLEX_TYPES describes all complex types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)		The user who owns the type
SCHEMA_URL	VARCHAR2(700)		The URL of the schema within which the type is defined Refer to the See Also note below for links to more information about the schemaurl attribute for an XML schema.
TARGET_NAMESPACE	VARCHAR2(2000)		The namespace of the type
COMPLEX_TYPE_NAME	VARCHAR2(256)		Name of the complex type
COMPLEX_TYPE	XMLTYPE(XMLSchema "http://xmlns.oracle.com/xdb/XDBSchema.xsd" Element "complexType")		The actual XMLType of the type
BASE_NAME	VARCHAR2(256)		Name of the base type to which the complex type refers
BASE_SCHEMA_URL	VARCHAR2(700)		The URL of the schema within which the complex type is defined
BASE_TARGET_NAMESPACE	VARCHAR2(2000)		The namespace of the type
MAINTAIN_DOM	RAW(1)		XDB annotation for maintainDOM
SQL_TYPE	VARCHAR2(128)		XDB annotation for sqlType
SQL_SCHEMA	VARCHAR2(128)		XDB annotation for sqlSchema

See Also:

• "DBA_XML_SCHEMA_COMPLEX_TYPES"

• "USER_XML_SCHEMA_COMPLEX_TYPES"

• Oracle XML DB Developer’s Guide for information about registering an XML schema with Oracle XML DB

• Oracle XML DB Developer’s Guide for information about restrictions for an XML schema URL