Oracle DBMS_XDB_CONSTANTS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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_ATTRIBUTE VARCHAR2(32) 'attribute'
C_COMPLEX_TYPE VARCHAR2(32) 'complexType'
C_DEFAULT_ENCODING VARCHAR2(32) C_UTF8_ENCODING
C_ELEMENT VARCHAR2(32) 'element'
C_GROUP VARCHAR2(32) 'group'
C_ISOLATIN1_ENCODING VARCHAR2(32) 'WE8ISO8859P1'
C_UTF8_ENCODING VARCHAR2(32) 'AL32UTF8'
C_WIN1252_ENCODING VARCHAR2(32) 'WE8MSWIN1252'
 
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_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_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_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 || '"'
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
Built-in Functions
Built-in Packages
DBMS_XDBREPOS
DBMS_XDB
DBMS_XDBREPOS
DBMS_XDBUTIL_INT
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved