DEVFYI - Developer Resource - FYI

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

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

356. 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.

(Continued on next question...)

Other Interview Questions