What is trigger
can any body explain me the uses of trigger in the database?
To maintain relationship between data.
When marital status is updated from "Married" to "Unmarried", trigger will delete the spouce and marriage details.
Trigger are backend validations that minimize front end coding/script
Last edited by dmasath; 04-17-2009 at 07:43 AM.
triggers are sql code that gets executed when certain events happen, and either before or after.
They can be BEFORE or AFTER
And tied to the operations INSERT, UPDATE, DELETE.
Many people use triggers +sequences to populate unique auto increment keys, as they're very fast. others use triggers for value validation. others use triggers to perform auditing (ie track when something was created/updated)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)