What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?

These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.

Interview Candidate
Sep 9th, 2004
1
11562

Oracle Forms 4.0

Answer

Showing Answers 1 - 1 of 1 Answers

raji

Mar 31st, 2006

hi Triggers are like stored pocedure consisting of batch of sql statements. ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS attached to the respective tables get fired when the tables gets manipulated by the query containing DML statements and checks for business logic inside the trigger object.