Untitled

SELECT owner, trigger_name, table_name, triggering_event, status
FROM all_triggers
WHERE trigger_name LIKE 'TRG_%'
ORDER BY owner, trigger_name;


SELECT owner, constraint_name, table_name, r_constraint_name
FROM all_constraints
WHERE constraint_type = 'R'
AND constraint_name LIKE 'FKY_%'
ORDER BY owner, constraint_name;