| 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 | |||||||||
|
||||||||||
