Oracle DBMS_RULE_EXP

Oracle DBMS_RULE_EXP_UTL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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$