Oracle | DBMS_RULE_EXP

Oracle DBMS_RULE_EXP_UTL 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 Rule Export Utilities

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_RULE_EXP_RS_INTERNAL	KU$_STATUS
DBMS_DATAPUMP	DBMS_RULE_EXP_RULES	OBJ$
DBMS_RULE_EXP_EC_INTERNAL	DBMS_RULE_EXP_RULE_SETS	USER$
DBMS_RULE_EXP_EV_CTXS	DBMS_SUM_RWEQ_EXPORT	V$DATABASE
DBMS_RULE_EXP_RL_INTERNAL	KU$_JOBSTATUS1220

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtreut.plb

Subprograms

ENQUOTE_LITERAL	EXPORT_ACTION	OBJECT_OWNER
ENQUOTE_NAME	IS_SYSTEM_EXPORT	PARSE_NAME

ENQUOTE_LITERAL

Double quotes a string literal dbms_rule_exp_utl.enquote_literal(str IN VARCHAR2) RETURN VARCHAR2;

Makes a call to DBMS_ASSERT ENQUOTE_LITERAL

ENQUOTE_NAME

Double quotes a valid object name dbms_rule_exp_utl.enquote_name(str IN VARCHAR2) RETURN VARCHAR2;

Makes a call to DBMS_ASSERT ENQUOTE_NAME

EXPORT_ACTION

Undocumented dbms_rule_exp_utl.export_action RETURN BOOLEAN;

BEGIN

        IF dbms_rule_exp_utl.export_action THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

IS_SYSTEM_EXPORT

Undocumented dbms_rule_exp_utl.is_system_export RETURN BOOLEAN;

BEGIN

        IF dbms_rule_exp_utl.is_system_export THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

OBJECT_OWNER

Undocumented dbms_rule_exp_utl.object_owner( obj_id IN NUMBER, obj_owner OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_rule_exp_utl.object_owner(18, outVal);

        dbms_output.put_line(outVal);

      END;

      /

      SYS

      

      PL/SQL procedure successfully completed.

PARSE_NAME

Undocumented dbms_rule_exp_utl.parse_name( full_name IN VARCHAR2, obsch IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rule_exp_utl.parse_name('sys.obj$', NULL)

      FROM dual;

      

      DBMS_RULE_EXP_UTL.PARSE_NAME('SYS.OBJ$',NULL)

      ----------------------------------------------

      SYS.OBJ$