Overlapping Ranges Blocker Toolkit: trigger-based solution to prevent overlapping ranges of data in an Oracle master table that stores range-based data, such as income tax brackets or sales commission rates.
Triggers
A database trigger is a piece of code (SQL, PL/SQL or Java statements) automatically fired by Oracle in response to certain events, such as whenever a DML statement is issued on a table/view or an event such as logon/logoff occurs. A trigger is typically used for maintaining the integrity of the information on the database.