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

How to Avoid Duplicate Entries When Inserting Data from Select and Except