Possible actions
[AFTER delay_interval] START step_1[,step_2 …]
STOP step_1[,step_2 …]
END [{end_value|step_name.error_code}]
Condition syntax
An expression that follows the condition syntax evaluates to a true
or false
.
«Fundamental Constructs that can be used to formulate chain conditions include
TRUE
FALSE
stepname [NOT] SUCCEEDED
stepname [NOT] FAILED
stepname [NOT] STOPPED
stepname [NOT] COMPLETED
stepname ERROR_CODE [NOT] IN (integer, integer, integer …)
stepname ERROR_CODE = integer
stepname ERROR_CODE != integer
stepname ERROR_CODE <> integer
stepname ERROR_CODE > integer
stepname ERROR_CODE >= integer
stepname ERROR_CODE < integer
stepname ERROR_CODE <= integer
Such «fundamental» constructs can be joined with the boolean operators OR
and AND
.
NOT(…)` inverses the value of an expression.
Rule types
select distinct
-- owner, -- SYS
lower(object_name) name,
object_type -- With one exception: TYPE
from
dba_objects
where
object_name like 'RE$%'
order by
lower(object_name);
re$attribute_value | |
re$attribute_value_list | varray(1024) of sys.re$attribute_value |
re$column_value | The value of a table column |
re$column_value_list | varray(1024) of sys.re$column_value |
re$name_array | varray(1024) of varchar2(128 byte); |
re$nv_array | list of name-value pairs |
re$nv_list | object(actx_list sys.re$nv_array) . The exception that has also a TYPE BODY with the members add_pair /remove_pair , get_all_names and get_value |
re$nv_node | varray(1024) of sys.re$nv_node |
re$rule_hit | A rule found as a result of an evaluation. (dbms_rule.get_next_hit ) |
re$rule_hit_list | varray(1024) of sys.re$rule_hit |
re$rule_list | |
re$table_alias | |
re$table_alias_list | varray(1024) of sys.re$table_alias |
re$table_value | Identification of a row in a table using a rowid |
re$table_value_list | varray(1024) of sys.re$table_value |
re$variable_type | type of a variable used in a rule evaluation context |
re$variable_type_list | |
re$variable_value | The value of a variable |
re$variable_value_list | |