[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_expr
(x_rule_id IN cn_rule_attr_expression.rule_id%TYPE) IS
BEGIN
UPDATE cn_attribute_rules
SET expression = ''
WHERE rule_id = x_rule_id;
DELETE FROM cn_rule_attr_expression
WHERE rule_id = x_rule_id;