Oracle | DBMS_XDB

Oracle DBMS_XDB_CONSTANTS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

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	NAMESPACE_XMLINSTANCE	SCHEMAELEM_RESCONTENT_TEXT
ENCODING_ISOLATIN1	NAMESPACE_XMLSCHEMA	SCHEMAELEM_RES_ACL
ENCODING_UTF8	NSPREFIX_ACL_ACL	SCHEMAURL_ACL
ENCODING_WIN1252	NSPREFIX_RESCONFIG_RC	SCHEMAURL_RESOURCE
NAMESPACE_ACL	NSPREFIX_RESOURCE_R	SCHEMAURL_XDBCONFIG
NAMESPACE_ORACLE	NSPREFIX_XDBCONFIG_CFG	SCHEMAURL_XDBSCHEMA
NAMESPACE_ORACLE_XDB	NSPREFIX_XDB_XDB	XDBSCHEMA_PREFIXES
NAMESPACE_RESOURCE	NSPREFIX_XMLDIFF_XD	XSD_ATTRIBUTE
NAMESPACE_RESOURCE_CONFIG	NSPREFIX_XMLINSTANCE_XSI	XSD_COMPLEX_TYPE
NAMESPACE_XDBCONFIG	NSPREFIX_XMLSCHEMA_XSD	XSD_ELEMENT
NAMESPACE_XDBSCHEMA	SCHEMAELEM_RESCONTENT_BINARY	XSD_GROUP
NAMESPACE_XMLDIFF

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 'https://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 'https://xmlns.oracle.com' xdb.dbms_xdb_constants.namespace_oracle RETURN VARCHAR2;

SELECT xdb.dbms_xdb_constants.namespace_oracle

      FROM dual;

NAMESPACE_ORACLE_XDB

Returns 'https://xmlns.oracle.com/xdb' xdb.dbms_xdb_constants.namespace_xdb RETURN VARCHAR2;

SELECT xdb.dbms_xdb_constants.namespace_xdb

      FROM dual;

NAMESPACE_RESOURCE

'https://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 'https://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 'https://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 'https://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 'https://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 'https://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 'https://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 = 'https://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 = "https://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 = "https://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 = "https://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 'https://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="https://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="https://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="https://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 'https://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 'https://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 'https://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 'https://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 'https://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 'https://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 'https://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="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

      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;