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.
Disables XDB Hierarchy for a particular xmltype table/view
dbms_xdbz.disable_hierarchy(
object_schema IN VARCHAR2,
object_name IN VARCHAR2,
hierarchy_type IN PLS_INTEGER := DISABLE_ALL,
delete_old_versions IN BOOLEAN := FALSE);
PRAGMA SUPPLEMENTAL_LOG_DATA(disable_hierarchy, AUTO_WITH_COMMIT);
Enables XDB Hierarchy for a particular xmltype table/view
dbms_xdbz.enable_hierarchy(
object_schema IN VARCHAR2,
object_name IN VARCHAR2,
hierarchy_type IN PLS_INGTEGER := ENABLE_CONTENTS,
schemareg IN BOOLEAN := FALSE);
PRAGMA SUPPLEMENTAL_LOG_DATA(enable_hierarchy, AUTO_WITH_COMMIT);
Checks if the XDB Hierarchy is enabled for a given xmltype table/view
dbms_xdbz.is_hierarchy_enabled(
object_schema IN VARCHAR2,
object_name IN VARCHAR2,
hierarchy_type IN PLS_INTEGER := IS_ENABLED_CONTENTS)
RETURN BOOLEAN;