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.

Thumbnail image for Stop Overlapping Ranges in a Table

Stop Overlapping Ranges in a Table

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.

Read the Full Article →
Thumbnail image for Auto-Increment Columns: FAQ

Auto-Increment Columns: FAQ

Auto-increment columns indatabase tables help to maintain uniqueness and track recency. Answers to frequently asked questions about auto-increment columns.

Read the Full Article →