Name
CREATE/ALTER/DROP TABLE (XML Syntax)
Synopsis
CREATE Syntax:
CREATE TABLE [schema.]table OF XMLTYPE
[XMLTYPE STORE AS
{OBJECT RELATIONAL
| CLOB
[{LOB_segname [(LOB_Parameter_Clause)]
| LOB_Parameter_Clause
}]
}]
[[XMLSCHEMA XMLSchema_URL] ELEMENT
{element
| XMLSchema_URL # element
}]ALTER Syntax:
ALTER TABLE [schema.]table_name{ ADD (columndatatype[DEFAULTexpr] [Column_Constraint_Clause] [,column datatype[DEFAULTexpr] [Column_Constraint_Clause] ...)] | MODIFY { (columndatatype[DEFAULTexpr] [Column_Constraint_Clause] [,column datatype[DEFAULTexpr] [Column_Constraint_Clause] ...)] XMLTYPE COLUMNcolumnSTORE AS {OBJECT RELATIONAL | CLOB [{ LOB_segname [(LOB_Parameter_Clause)] | LOB_Parameter_Clause }] }] [[XMLSCHEMA XMLSchema_URL] ELEMENT {element | XMLSchema_URL # element }]
DROP Syntax:
DROP TABLE [schema.]table_name[CASCADE CONSTRAINTS]
Creates, modifies, or drops an XML table. New with Oracle9i Release 2.
Keywords
- STORE AS
Specifies how Oracle manages the storage of the underlying columns. New with Oracle9i.
- OBJECT RELATIONAL
Specifies that Oracle is to store the XMLType data in object-relational columns. If you specify OBJECT RELATIONAL, then you must also specify an XMLSchema in the XMLSCHEMA clause, and you must already have registered the schema (using the built-in DBMS_XMLSCHEMA package). Oracle will create the table conforming to the registered schema.
- CLOB
Specifies that Oracle is to store the XML data in a CLOB column. If you specify CLOB, then you may also ...