Oracle DBMS_XMLSCHEMA_ANNOTATE Version 21c |
---|
General Information | |||||||||
Library Note |
|
||||||||
Purpose | XML Annotation Support | ||||||||
AUTHID | CURRENT_USER | ||||||||
Dependencies |
|
||||||||
Documented | No | ||||||||
Exceptions |
|
||||||||
First Available | 12.1 | ||||||||
Pragma | PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE); | ||||||||
Security Model | Owned by XDB with EXECUTE granted to PUBLIC | ||||||||
Source | {ORACLE_HOME}/rdbms/admin/dbmsxutil.sql {ORACLE_HOME}/rdbms/admin/prvtxutil.plb |
||||||||
Subprograms |
|
||||||||
ADDXDBNAMESPACE | |||||||||
Adds the XDB namespace required for XDB annotation | dbms_xmlschema_annotate.addXDBNamespace(xmlschema IN OUT XMLType); |
||||||||
TBD | |||||||||
DISABLEDEFAULTTABLECREATION | |||||||||
Add a default table attribute with an empty value to the top level element with the specified name Overload 1 |
dbms_xmlschema_annotate.disbleDeaultTableCreation( |
||||||||
TBD | |||||||||
Add a default table attribute with an empty value to ALL top level elements that have no defined default table name Overload 2 |
dbms_xmlschema_annotate.disbleDeaultTableCreation(xmlschema
IN OUT XMLType); |
||||||||
TBD | |||||||||
DISABLEMAINTAINDOM | |||||||||
sets DOM fidelity to FALSE to ALL complex types irregardless of their names Overload 1 |
dbms_xmlschema_annotate.disableMaintainDOM( |
||||||||
TBD | |||||||||
Sets the DOM fidelity attribute for the given complex type name to FALSE Overload 2 |
dbms_xmlschema_annotate.disableMaintainDOM( |
||||||||
TBD | |||||||||
ENABLEDEFAULTTABLECREATION | |||||||||
Enables the creation of top level tables by removing the empty default table name annotation. Overload 1 |
dbms_xmlschema_annotate.enableDefaultTableCreation( |
||||||||
TBD | |||||||||
Enables the creation of ALL top level tables by removing the empty default table name annotation. Overload 2 |
dbms_xmlschema_annotate.enableDefaultTableCreation(xmlschema IN OUT XMLType); |
||||||||
TBD | |||||||||
ENABLEMAINTAINDOM | |||||||||
Sets DOM fidelity to TRUE to ALL complex types irregardless of their names Overload 1 |
dbms_xmlschema_annotate.enableMaintainDOM( |
||||||||
TBD | |||||||||
Sets the DOM fidelity attribute for the given complex type name to TRUE Overload 2 |
dbms_xmlschema_annotate.enableMaintainDOM( |
||||||||
TBD | |||||||||
GETSCHEMAANNOTATIONS | |||||||||
Creates a diff of the annotated XML schema and the non-annotated XML schema | dbms_xmlschema_annotate.getSchemaNotations(xmlschema
IN xmlType) RETURN XMLType; |
||||||||
TBD | |||||||||
PRINTWARNINGS | |||||||||
Undocumented | dbms_xmlschema_annotate.printWarnings(value IN BOOLEAN DEFAULT TRUE); |
||||||||
TBD | |||||||||
REMOVEANYSTORAGE | |||||||||
Removes the sqltype of any | dbms_xmlschema_annotate.removeAnyStorage( |
||||||||
TBD | |||||||||
REMOVEDEFAULTTABLE | |||||||||
Removes the default table attribute for the given element. After calling this function system generated table names will be used | dbms_xmlschema_annotate.removeDefaultTable( |
||||||||
TBD | |||||||||
REMOVEMAINTAINDOM | |||||||||
Removes all maintain DOM annotations from given schema | dbms_xmlschema_annotate.removeMaintainDOM(xmlschema IN OUT XMLType); |
||||||||
TBD | |||||||||
REMOVEOUTOFLINE | |||||||||
Removes the sqlInline attribute for the element specified by its name Overload 1 |
dbms_xmlschema_annotate.removeOutOfLine( |
||||||||
TBD | |||||||||
Removes the sqlInline attribute for the element specified by its global and local name Overload 2 |
dbms_xmlschema_annotate.removeOutOfLine( |
||||||||
TBD | |||||||||
Overload 3 | dbms_xmlschema_annotate.removeOutOfLine( |
||||||||
TBD | |||||||||
REMOVESQLCOLLTYPE | |||||||||
Removes the sql collection type | dbms_xmlschema_annotate.removeSQLCollType( |
||||||||
TBD | |||||||||
REMOVESQLNAME | |||||||||
Removes a sqlname from a global element | dbms_xmlschema_annotate.removeSQLName( |
||||||||
TBD | |||||||||
REMOVESQLTYPE | |||||||||
Removes a sqltype from a global element Overload 1 |
dbms_xmlschema_annotate.removeSQLType( |
||||||||
TBD | |||||||||
Removes a sqltype inside a complex type (local) Overload 2 |
dbms_xmlschema_annotate.removeSQLType( |
||||||||
TBD | |||||||||
REMOVESQLTYPEMAPPING | |||||||||
Removes the sqltype mapping for the given schema type | dbms_xmlschema_annotate.removeSQLTypeMapping( |
||||||||
TBD | |||||||||
REMOVETABLEPROPS | |||||||||
Removes the table storage props Overload 1 |
dbms_xmlschema_annotate.removeTableProps( |
||||||||
TBD | |||||||||
Removes the TABLE storage clause that is appended to the default CREATE TABLE statement. Overload 2 |
dbms_xmlschema_annotate.removeTableProps( |
||||||||
TBD | |||||||||
REMOVETIMESTAMPWITHTIMEZONE | |||||||||
Removes the TimeStampWithTimeZone datatype to dateTime typed element | dbms_xmlschema_annotate.removeTimestampWithTimezone(xmlschema IN OUT xmlType); |
||||||||
TBD | |||||||||
SETANYSTORAGE | |||||||||
Sets the sqltype of any | dbms_xmlschema_annotate.setanyStorage( |
||||||||
TBD | |||||||||
SETDEFAULTTABLE | |||||||||
Sets the name of the default table for a given global element that is specified by its name | dbms_xmlschema_annotate.setDefaultTable( |
||||||||
TBD | |||||||||
SETOUTOFLINE | |||||||||
Set the sqlInline attribute to FALSE and forces the out of line storage for the element specified by its name Overload 1 |
dbms_xmlschema_annotate.setOutOfLine( |
||||||||
TBD | |||||||||
Set the sqlInline attribute to FALSE and forces the out of line storage for the element specified by its local and global name Overload 2 |
dbms_xmlschema_annotate.setOutOfLine( |
||||||||
TBD | |||||||||
Sets the default table name and sqlinline attribute for all references to a particular global Element Overload 3 |
dbms_xmlschema_annotate.setOutOfLine( |
||||||||
TBD | |||||||||
SETSCHEMAANNOTATIONS | |||||||||
Accepts annotations (diff result from call to 'getSchemaAnnotations' and patches in the provided XML schema | dbms_xmlschema_annotate.setSchemaAnnotations( |
||||||||
TBD | |||||||||
SETSQLCOLLTYPE | |||||||||
Name of the SQL collection type that corresponds to this XML element. inside a complex type Overload 1 |
dbms_xmlschema_annotate.setSQLCollType( |
||||||||
TBD | |||||||||
Overload 2 | dbms_xmlschema_annotate.setSQLCollType( |
||||||||
TBD | |||||||||
SETSQLNAME | |||||||||
Assigns a sqlname to an element | dbms_xmlschema_annotate.setSQLName( |
||||||||
TBD | |||||||||
SETSQLTYPE | |||||||||
Assigns a sqltype to a global element Overload 1 |
dbms_xmlschema_annotate.setSQLType( |
||||||||
TBD | |||||||||
Assigns a sqltype inside a complex type (local) Overload 2 |
dbms_xmlschema_annotate.setSQLType( |
||||||||
TBD | |||||||||
SETSQLTYPEMAPPING | |||||||||
Defines a mapping of schema type and sqltype | dbms_xmlschema_annotate.setSQLTypeMapping( |
||||||||
TBD | |||||||||
SETTABLEPROPS | |||||||||
Specifies the TABLE storage clause that is appended to the default CREATE TABLE statement Overload 1 |
dbms_xmlschema_annotate.setTableProps( |
||||||||
TBD | |||||||||
Specifies the TABLE storage clause
that is appended to the default CREATE TABLE statement Overload 2 |
dbms_xmlschema_annotate.setTableProps( |
||||||||
TBD | |||||||||
SETTIMESTAMPWITHTIMEZONE | |||||||||
Sets the TimeStampWithTimeZone datatype to dateTime typed element | dbms_xmlschema_annotate.setTimestampWithTimezone( |
||||||||
TBD |
Related Topics |
Built-in Functions |
Built-in Packages |
Database Security |
What's New In 21c |
What's New In 23c |
This site is maintained by Dan Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||