How to Retrieve Data from One Table and Insert It into Another Based on Matching Columns in SQL

How to Define an Oracle Trigger for Self-Referential Tables While Avoiding Infinite Loops