The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE select_columns (X_trigger_id IN OUT number,
X_trigger_name IN OUT varchar2,
X_table_name IN OUT varchar2) IS
BEGIN
SELECT trg.name, tab.name
INTO X_trigger_name, X_table_name
FROM cn_obj_triggers_v trg,
cn_obj_tables_v tab
WHERE trg.trigger_id = X_trigger_id
AND tab.table_id = trg.table_id;
END select_columns;
PROCEDURE delete_row (X_trigger_ID number) IS
BEGIN
UPDATE cn_obj_triggers_v
SET event_id = NULL
WHERE trigger_id = X_trigger_id;
END delete_row;
PROCEDURE Insert_Row (X_trigger_id number,
X_event_id number) IS
BEGIN
UPDATE cn_obj_triggers_v
SET event_id = X_event_id
WHERE trigger_id = X_trigger_id;
END Insert_Row;
SELECT trigger_id
INTO Dumy
FROM cn_obj_triggers_v
WHERE trigger_id = X_trigger_ID
FOR UPDATE OF cn_obj_triggers_v.event_id;
SELECT trg.table_id, tab.name
INTO X_table_id, X_table_name
FROM cn_obj_triggers_v trg,
cn_obj_tables_v tab
WHERE trg.trigger_id = X_trigger_id
AND tab.table_id = trg.table_id;