General Information
Library Note
Morgan's Library Page Header
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."
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_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)
'https://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)
'https://www.w3.org/2001/XMLSchema-instance'
C_XMLINSTANCE_PREFIX_XSI VARCHAR2(128)
'xmlns:xsi="' || C_XMLINSTANCE_NAMESPACE || '"'
C_XMLSCHEMA_NAMESPACE VARCHAR2(128)
'https://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
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 ;
ENCODING_ISOLATIN1
Returns 'WE8ISO8859P1'
xdb.dbms_xdb_constants.encoding_isolatin1 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_isolatin1 ;
ENCODING_UTF8
Returns 'AL32UTF8'
xdb.dbms_xdb_constants.encoding_utf8 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_utf8 ;
ENCODING_WIN1252
Returns 'WE8MSWIN1252'
xdb.dbms_xdb_constants.encoding_win1252 RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.encoding_win1252 ;
NAMESPACE_ACL
Returns 'https://xmlns.oracle.com/xdb/acl.xsd'
xdb.dbms_xdb_constants.namespace_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_acl ;
NAMESPACE_ORACLE
Returns 'https://xmlns.oracle.com'
xdb.dbms_xdb_constants.namespace_oracle RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_oracle ;
NAMESPACE_ORACLE_XDB
Returns 'https://xmlns.oracle.com/xdb'
xdb.dbms_xdb_constants.namespace_xdb RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xdb ;
NAMESPACE_RESOURCE
'https://xmlns.oracle.com/xdb/XDBResource.xsd'
xdb.dbms_xdb_constants.namespace_resource RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_resource ;
NAMESPACE_RESOURCE_CONFIG
Returns 'https://xmlns.oracle.com/XDBResConfig.xsd'
xdb.dbms_xdb_constants.namespace_resource_config RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_resource_config ;
NAMESPACE_XDBCONFIG
Returns 'https://xmlns.oracle.com/xdb/xdbconfig.xsd'
xdb.dbms_xdb_constants.namespace_xdbConfig RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xdbConfig ;
NAMESPACE_XDBSCHEMA
Returns 'https://xmlns.oracle.com/xdb/XDBSchema.xsd'
xdb.dbms_xdb_constants.namespace_xdbSchema RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xdbSchema ;
NAMESPACE_XMLDIFF
Returns 'https://xmlns.oracle.com/xdb/xdiff.xsd'
xdb.dbms_xdb_constants.namespace_xmlDiff RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlDiff ;
NAMESPACE_XMLINSTANCE
Returns 'https://www.w3.org/2001/XMLSchema-instance'
xdb.dbms_xdb_constants.namespace_xmlInstance RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlInstance ;
NAMESPACE_XMLSCHEMA
Returns 'https://www.w3.org/2001/XMLSchema'
xdb.dbms_xdb_constants.namespace_xmlSchema RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.namespace_xmlSchema ;
NSPREFIX_ACL_ACL
Returns 'xmlns:acl = 'https://xmlns.oracle.com/acs.xsd'
xdb.dbms_xdb_constants.nsprefix_acl_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_acl_acl ;
NSPREFIX_RESCONFIG_RC
Returns 'xmlns:rc =
"https://xmlns.oracle.com/xdb/XDBResConfig.xsd"'
xdb.dbms_xdb_constants.nsprefix_resconfig_rc RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_resconfig_rc ;
NSPREFIX_RESOURCE_R
Returns 'xmlns:r = "https://xmlns.oracle.com/XDBResource.xsd'
xdb.dbms_xdb_constants.nsprefix_resource_r RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_resource_r ;
NSPREFIX_XDBCONFIG_CFG
Returns 'xmlns:cfg = "https://xmlns.oracle.com/xdb/xdbconfig.xsd"'
dbms_xdb_constants.nsprefix_xdbConfig_cfg RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xdbConfig_cfg ;
NSPREFIX_XDB_XDB
Returns 'https://xmlns.oracle.com/xdb'
dbms_xdb_constants.nsprefix_xdb_xdb RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xdb_xdb ;
NSPREFIX_XMLDIFF_XD
Returns 'xmlns:xd="https://xmlns.oracle.com/xdb/xdiff.xsd'
dbms_xdb_constants.nsprefix_xmlDiff_xd RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xmlDiff_xd ;
NSPREFIX_XMLINSTANCE_XSI
Returns 'xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance"'
dbms_xdb_constants.nsprefix_xmlInstance_xsi RETURN VARCHAR2
SELECT xdb.dbms_xdb_constants.nsprefix_xmlInstance_xsi ;
NSPREFIX_XMLSCHEMA_XSD
Returns 'xmlns:xsd="https://www.w3.org/2001/XMLSchema"'
dbms_xdb_constants.nsprefix_xmlSchema_xsd RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.nsprefix_xmlSchema_xsd ;
SCHEMAELEM_RESCONTENT_BINARY
Returns 'https://xmlns.oracle.com/xdb/XDBSchema.xsd#binary'
dbms_xdb_constants.schemaElem_rescontent_binary RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_rescontent_binary ;
SCHEMAELEM_RESCONTENT_TEXT
Returns 'https://xmlns.oracle.com/xdb/XDBSchema.xsd#text'
dbms_xdb_constants.schemaElem_resContent_text RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_resContent_text ;
SCHEMAELEM_RES_ACL
Returns 'https://xmlns.oracle.com/xdb/acl.xsd#acl'
dbms_xdb_constants.schemaElem_res_acl RETURN VARCHAR2;
SELECT dbms_xdb_constants.schemaElem_res_acl ;
SCHEMAURL_ACL
Returns 'https://xmlns.oracle.com/xdb/acl.xsd'
xdb.dbms_xdb_constants.schemaURL_acl RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaurl_acl ;
SCHEMAURL_RESOURCE
Returns 'https://xmlns.oracle.com/xdb/XDBResource.xsd'
xdb.dbms_xdb_constants.schemaURL_resource RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_resource ;
SCHEMAURL_XDBCONFIG
Returns 'https://xmlns.oracle.com/xdb/xdbconfig.xsd'
xdb.dbms_xdb_constants.schemaURL_xdbConfig RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_xdbConfig ;
SCHEMAURL_XDBSCHEMA
Returns 'https://xmlns.oracle.com/xdb/XDBSchema.xsd'
xdb.dbms_xdb_constants.schemaURL_xdbSchema RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.schemaURL_xdbSchema ;
XDBSCHEMA_PREFIXES
Returns 'xmlns:xsd="https://www.w3.org/2001/XMLSchema" xmlns:xdb="https://xmlns.oracle.com/xdb"'
xdb.dbms_xdb_constants.xdbSchema_prefixes RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xdbSchema_prefixes ;
XSD_ATTRIBUTE
Returns 'attribute'
xdb.dbms_xdb_constants.xsd_attribute RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_attribute ;
XSD_COMPLEX_TYPE
Returns 'complexType'
xdb.dbms_xdb_constants.xsd_complex_type RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_complex_type ;
XSD_ELEMENT
Returns 'element'
xdb.dbms_xdb_constants.xsd_element RETURN VARCHAR2;
SELECT dbms_xdb_constants.xsd_element ;
XSD_GROUP
Returns 'group'
xdb.dbms_xdb_constants.xsd_group RETURN VARCHAR2;
SELECT xdb.dbms_xdb_constants.xsd_group ;