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