Oracle DBMS_XDB_CONSTANTS
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Provides an interface to commonly used constants. According to the code comments from Oracle: "Users should use constants instead of dynamic strings to avoid typographical errors."

I agree in some cases ... no one should be writing strings into their code like those returned by XDBSCHEMA_PREFIXES. But if you need to write a function like XSD_GROUP then I recommend you get another profession.
AUTHID CURRENT_USER
Constants
Name Data Type Value
C_ACL_CONTENT VARCHAR2(128) C_ACL_LOCATION || '#acl'
C_ACL_LOCATION VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/acl.xsd'
C_ACL_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/acl.xsd'
C_ACL_PREFIX_ACL VARCHAR2(128) 'xmlns:acl="' || C_ACL_NAMESPACE || '"'
C_BINARY_CONTENT VARCHAR2(128) C_XDBSCHEMA_LOCATION || '#binary'
C_DEFAULT_ENCODING VARCHAR2(32) C_UTF8_ENCODING
C_DICOM_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/ord/meta/dicomImage'
C_DICOM_PREFIX_DICOM VARCHAR2(128) 'xmlns:dicom="' || C_DICOM_NAMESPACE || '"'
C_EXIF_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/ord/meta/exif'
C_EXIF_PREFIX_EXIF VARCHAR2(128) 'xmlns:exif="' || C_EXIF_NAMESPACE || '"'
C_IPTC_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/ord/meta/iptc'
C_IPTC_PREFIX_IPTC VARCHAR2(128) 'xmlns:iptc="' || C_IPTC_NAMESPACE || '"'
C_ISOLATIN1_ENCODING VARCHAR2(32) 'WE8ISO8859P1'
C_NSPREFIX_XDBCONFIG_CFG VARCHAR2(128) 'xmlns:cfg="' || C_XDBCONFIG_NAMESPACE || '"'
C_ORACLE_NAMESPACE VARCHAR2(128) 'http://xmlns.oracle.com'
C_ORACLE_XDB_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/xdb'
C_ORDIMAGE_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/ord/meta/ordimage'
C_ORDIMAGE_PREFIX_ORD VARCHAR2(128) 'xmlns:ord="' || C_ORDIMAGE_NAMESPACE || '"'
C_RESOURCE_CONFIG_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/XDBResConfig.xsd'
C_RESOURCE_CONFIG_PREFIX_RC VARCHAR2(128) 'xmlns:rc="' || C_RESOURCE_CONFIG_NAMESPACE || '"'
C_RESOURCE_LOCATION VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/XDBResource.xsd'
C_RESOURCE_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/XDBResource.xsd'
C_RESOURCE_PREFIX_R VARCHAR2(128) 'xmlns:r="' || C_RESOURCE_NAMESPACE || '"'
C_TEXT_CONTENT VARCHAR2(128) C_XDBSCHEMA_LOCATION || '#text'
C_UTF8_ENCODING VARCHAR2(32) 'AL32UTF8'
C_WIN1252_ENCODING VARCHAR2(32) 'WE8MSWIN1252'
C_XDBCONFIG_LOCATION VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/xdbconfig.xsd'
C_XDBCONFIG_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/xdbconfig.xsd'
C_XDBSCHEMA_LOCATION VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/XDBSchema.xsd'
C_XDBSCHEMA_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/XDBSchema.xsd'
C_XDBSCHEMA_PREFIXES VARCHAR2(128) C_XMLSCHEMA_PREFIX_XSD || ' ' || C_XDBSCHEMA_PREFIX_XDB
C_XDBSCHEMA_PREFIX_XDB VARCHAR2(128) 'xmlns:xdb="' || C_ORACLE_XDB_NAMESPACE || '"'
C_XMLDIFF_NAMESPACE VARCHAR2(128) C_ORACLE_XDB_NAMESPACE || '/xdiff.xsd'
C_XMLDIFF_PREFIX_XD VARCHAR2(128) 'xmlns:xd="' || C_XMLDIFF_NAMESPACE || '"'
C_XMLINSTANCE_NAMESPACE VARCHAR2(128) 'http://www.w3.org/2001/XMLSchema-instance'
C_XMLINSTANCE_PREFIX_XSI VARCHAR2(128) 'xmlns:xsi="' || C_XMLINSTANCE_NAMESPACE || '"'
C_XMLSCHEMA_NAMESPACE VARCHAR2(128) 'http://www.w3.org/2001/XMLSchema'
C_XMLSCHEMA_PREFIX_XSD VARCHAR2(128) 'xmlns:xsd="' || C_XMLSCHEMA_NAMESPACE || '"'
C_XMP_NAMESPACE VARCHAR2(128) C_ORACLE_NAMESPACE || '/ord/meta/xmp'
C_XMP_PREFIX_XMP VARCHAR2(128) 'xmlns:xmp="' || C_XMP_NAMESPACE || '"'
 
C_ATTRIBUTE VARCHAR2(32) 'attribute'
C_COMPLEX_TYPE VARCHAR2(32) 'complexType'
C_ELEMENT VARCHAR2(32) 'element'
C_GROUP VARCHAR2(32) 'group'
Dependencies
DBMS_XMLSCHEMA_ANNOTATE    
Documented Yes
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsxutil.sql
Subprograms
 
ENCODING_DEFAULT
Returns 'AL32UTF8' xdb.dbms_xdb_constants.encoding_default RETURN VARCHAR2
SELECT xdb.dbms_xdb_constants.encoding_default
FROM dual;
 
ENCODING_ISOLATIN1
Returns 'WE8ISO8859P1' xdb.dbms_xdb_constants.encoding_isolatin1 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_isolatin1
FROM dual;
 
ENCODING_UTF8
Returns 'AL32UTF8' xdb.dbms_xdb_constants.encoding_utf8 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_utf8
FROM dual;
 
ENCODING_WIN1252
Returns 'WE8MSWIN1252' xdb.dbms_xdb_constants.encoding_win1252 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_win1252
FROM dual;
 
NAMESPACE_ACL
Returns 'http://xmlns.oracle.com/xdb/acl.xsd' xdb.dbms_xdb_constants.namespace_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_acl
FROM dual;
 
NAMESPACE_ORACLE
Returns 'http://xmlns.oracle.com' xdb.dbms_xdb_constants.namespace_oracle RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_oracle
FROM dual;
 
NAMESPACE_ORACLE_XDB
Returns 'http://xmlns.oracle.com/xdb' xdb.dbms_xdb_constants.namespace_xdb RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xdb
FROM dual;
 
NAMESPACE_RESOURCE
'http://xmlns.oracle.com/xdb/XDBResource.xsd' xdb.dbms_xdb_constants.namespace_resource RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_resource
FROM dual;
 
NAMESPACE_RESOURCE_CONFIG
Returns 'http://xmlns.oracle.com/XDBResConfig.xsd' xdb.dbms_xdb_constants.namespace_resource_config RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_resource_config
FROM dual;
 
NAMESPACE_XDBCONFIG
Returns 'http://xmlns.oracle.com/xdb/xdbconfig.xsd' xdb.dbms_xdb_constants.namespace_xdbConfig RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xdbConfig
FROM dual;
 
NAMESPACE_XDBSCHEMA
Returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd' xdb.dbms_xdb_constants.namespace_xdbSchema RETURN VARCHAR2
SELECT xdb.dbms_xdb_constants.namespace_xdbSchema
FROM dual;
 
NAMESPACE_XMLDIFF
Returns 'http://xmlns.oracle.com/xdb/xdiff.xsd' xdb.dbms_xdb_constants.namespace_xmlDiff RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlDiff
FROM dual;
 
NAMESPACE_XMLINSTANCE
Returns 'http://www.w3.org/2001/XMLSchema-instance' xdb.dbms_xdb_constants.namespace_xmlInstance RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlInstance
FROM dual;
 
NAMESPACE_XMLSCHEMA
Returns 'http://www.w3.org/2001/XMLSchema' xdb.dbms_xdb_constants.namespace_xmlSchema RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlSchema
FROM dual;
 
NSPREFIX_ACL_ACL
Returns 'xmlns:acl='http://xmlns.oracle.com/acs.xsd' xdb.dbms_xdb_constants.nsprefix_acl_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_acl_acl
FROM dual;
 
NSPREFIX_RESCONFIG_RC
Returns 'xmlns:rc="http://xmlns.oracle.com/xdb/XDBResConfig.xsd"' xdb.dbms_xdb_constants.nsprefix_resconfig_rc RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_resconfig_rc
FROM dual;
 
NSPREFIX_RESOURCE_R
Returns 'xmlns:r="http://xmlns.oracle.com/XDBResource.xsd' xdb.dbms_xdb_constants.nsprefix_resource_r RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_resource_r
FROM dual;
 
NSPREFIX_XDBCONFIG_CFG
Returns 'xmlns:cfg="http://xmlns.oracle.com/xdb/xdbconfig.xsd"' dbms_xdb_constants.nsprefix_xdbConfig_cfg RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xdbConfig_cfg
FROM dual;
 
NSPREFIX_XDB_XDB
Returns 'http://xmlns.oracle.com/xdb' dbms_xdb_constants.nsprefix_xdb_xdb RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xdb_xdb
FROM dual;
 
NSPREFIX_XMLDIFF_XD
Returns 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd' dbms_xdb_constants.nsprefix_xmlDiff_xd RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xmlDiff_xd
FROM dual;
 
NSPREFIX_XMLINSTANCE_XSI
Returns 'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"' dbms_xdb_constants.nsprefix_xmlInstance_xsi RETURN VARCHAR2
SELECT xdb.dbms_xdb_constants.nsprefix_xmlInstance_xsi
FROM dual;
 
NSPREFIX_XMLSCHEMA_XSD
Returns 'xmlns:xsd="http://www.w3.org/2001/XMLSchema"' dbms_xdb_constants.nsprefix_xmlSchema_xsd RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xmlSchema_xsd
FROM dual;
 
SCHEMAELEM_RESCONTENT_BINARY
Returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd#binary' dbms_xdb_constants.schemaElem_rescontent_binary RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_rescontent_binary
FROM dual;
 
SCHEMAELEM_RESCONTENT_TEXT
Returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd#text' dbms_xdb_constants.schemaElem_resContent_text RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_resContent_text
FROM dual;
 
SCHEMAELEM_RES_ACL
Returns 'http://xmlns.oracle.com/xdb/acl.xsd#acl' dbms_xdb_constants.schemaElem_res_acl RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_res_acl
FROM dual;
 
SCHEMAURL_ACL
Returns 'http://xmlns.oracle.com/xdb/acl.xsd' xdb.dbms_xdb_constants.schemaURL_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaurl_acl
FROM dual;
 
SCHEMAURL_RESOURCE
Returns 'http://xmlns.oracle.com/xdb/XDBResource.xsd' xdb.dbms_xdb_constants.schemaURL_resource RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_resource
FROM dual;
 
SCHEMAURL_XDBCONFIG
Returns 'http://xmlns.oracle.com/xdb/xdbconfig.xsd' xdb.dbms_xdb_constants.schemaURL_xdbConfig RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_xdbConfig
FROM dual;
 
SCHEMAURL_XDBSCHEMA
Returns 'http://xmlns.oracle.com/xdb/XDBSchema.xsd' xdb.dbms_xdb_constants.schemaURL_xdbSchema RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_xdbSchema
FROM dual;
 
XDBSCHEMA_PREFIXES
Returns 'xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xdb="http://xmlns.oracle.com/xdb"' xdb.dbms_xdb_constants.xdbSchema_prefixes RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xdbSchema_prefixes
FROM dual;
 
XSD_ATTRIBUTE
Returns 'attribute' xdb.dbms_xdb_constants.xsd_attribute RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_attribute
FROM dual;
 
XSD_COMPLEX_TYPE
Returns 'complexType' xdb.dbms_xdb_constants.xsd_complex_type RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_complex_type
FROM dual;
 
XSD_ELEMENT
Returns 'element' xdb.dbms_xdb_constants.xsd_element RETURN VARCHAR2;
SELECT dbms_xdb_constants.xsd_element
FROM dual;
 
XSD_GROUP
Returns 'group' xdb.dbms_xdb_constants.xsd_group RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_group
FROM dual;

Related Topics
DBMS_XDBREPOS
DBMS_XDB
DBMS_XDBREPOS
DBMS_XDBUTIL_INT
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
Packages

Morgan's Library Page Footer
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-2014 Daniel A. Morgan All Rights Reserved