| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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);
DBMS_RULE_EXP_UTL.PARSE_NAME('SYS.OBJ$',NULL)
----------------------------------------------
SYS.OBJ$ |