DISABLE_RULE

The DISABLE_RULE procedure is used to disable a custom rewrite rule, making it ineffective.

Syntax

PROCEDURE DISABLE_RULE (
    rule_name          VARCHAR(256));

Parameters

Parameter	Description
rule_name	The name of the rule.

Example

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

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