[Home] [Help]
[Dependency Information]
TABLE: SYS.RULE$
Object Details
Object Name: | RULE$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_RULE
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
|
SYS_IL0000227180C00002$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
SYS_IL0000227180C00005$$
|
LOB
|
UNIQUE
|
SYSTEM
|
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
CONDITION |
CLOB |
(4000) |
|
|
ECTX# |
NUMBER |
|
|
|
R_ACTION |
RE$NV_LIST |
(1) |
|
|
PROPERTY |
NUMBER |
|
Yes |
|
R_COMMENT |
VARCHAR2 |
(4000) |
|
|
UACTX_CLIENT |
VARCHAR2 |
(128) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, CONDITION
, ECTX#
, R_ACTION
, PROPERTY
, R_COMMENT
, UACTX_CLIENT
FROM SYS.RULE$;
Dependencies
[top of page]
SYS.RULE$ references the following:
-
SYS
-
RE$NV_ARRAY
-
RE$NV_LIST
-
RE$NV_NODE
-
STANDARD
- show dependent code
SYS.RULE$ is referenced by following:
-
SYS
-
ALL_RULES
-
ALL_SCHEDULER_CHAIN_RULES
-
DBA_RULES
-
DBA_SCHEDULER_CHAIN_RULES
-
DBMS_RULE_COMPATIBLE_90
- show dependent code
-
DBMS_RULE_EXP_RL_INTERNAL
- show dependent code
-
DBMS_RULE_EXP_RS_INTERNAL
- show dependent code
-
USER_RULES
-
USER_SCHEDULER_CHAIN_RULES
-
_DBA_RULES1
-
_DBA_STREAMS_RULES_H