ENABLE_RULE

The ENABLE_RULE procedure enables a custom rewrite rule so that it takes effect.

Syntax

PROCEDURE ENABLE_RULE (
    rule_name          VARCHAR(256));

Parameters

Parameter	Description
rule_name	The name of the rule.

Examples

CALL DBMS_UDR.ENABLE_RULE('rule1');
Query OK, 0 rows affected 

SELECT 1 FROM DUAL;
+-------+
| ? + 1 |
+-------+
|     2 |
+-------+
1 row in set