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;
Leave a Comment