Untitled

SELECT 
    t.owner, 
    t.trigger_name, 
    t.table_name, 
    t.triggering_event, 
    t.status,
    o.LAST_DDL_TIME AS created_time,
    fk.constraint_name AS foreign_key_name,
    fk_col.column_name AS foreign_key_column,
    fk.r_constraint_name AS referenced_constraint_name,
    ref_col.table_name AS referenced_table_name,
    ref_col.column_name AS referenced_column_name
FROM 
    all_triggers t
JOIN 
    all_objects o 
    ON (t.owner = o.owner AND t.trigger_name = o.object_name)
LEFT JOIN 
    all_constraints fk 
    ON (t.owner = fk.owner AND t.table_name = fk.table_name AND fk.constraint_type = 'R')
LEFT JOIN 
    all_cons_columns fk_col 
    ON (fk.owner = fk_col.owner AND fk.constraint_name = fk_col.constraint_name)
LEFT JOIN 
    all_constraints ref 
    ON (fk.r_owner = ref.owner AND fk.r_constraint_name = ref.constraint_name)
LEFT JOIN 
    all_cons_columns ref_col 
    ON (ref.owner = ref_col.owner AND ref.constraint_name = ref_col.constraint_name AND ref_col.position = fk_col.position)
WHERE 
    t.trigger_name LIKE 'TRG_%'
    AND o.owner = 'RMS'
    AND o.LAST_DDL_TIME > TIMESTAMP '2024-12-23 14:39:00'
ORDER BY 
    o.LAST_DDL_TIME DESC;