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
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$

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_ASSERT
DBMS_RULE
DBMS_RULE_ADM
DBMS_RULE_EXPIMP
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RL_INTERNAL
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTLI
DBMS_RULE_IMP_OBJ
DBMS_RULE_INTERNAL
DBMS_SUM_RWEQ_EXPORT
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx