The DISABLE_RULE procedure disables a user-defined rewrite rule.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
PROCEDURE DISABLE_RULE (
rule_name VARCHAR(256));
Parameters
| Parameter | Description |
|---|---|
| rule_name | The name of the rule. |
Examples
obclient> CALL DBMS_UDR.DISABLE_RULE('rule1');
Query OK, 0 rows affected
obclient> SELECT 1 FROM DUAL;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set