Purpose
The oceanbase.DBA_OB_USER_DEFINED_RULES view displays the rules for customizing SQL statements.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DB_NAME | varchar(128) | NO | The database name specified when the rule is defined. |
| RULE_NAME | varchar(256) | NO | The name of the rule. |
| RULE_ID | bigint(20) | NO | The ID of the rule. |
| PATTERN | longtext | NO | The pattern to which the rule matches. |
| REPLACEMENT | longtext | NO | Indicates how to rewrite a statement template that matches a pattern. |
| NORMALIZED_PATTERN | longtext | NO | The pattern after parameterization. |
| STATUS | varchar(10) | NO |
|
| VERSION | bigint(20) | NO | The version number of the rule. |
| PATTERN_DIGEST | bigint(20) unsigned | NO | The HASH value of NORMALIZED_PATTERN. |