DEVFYI - Developer Resource - FYI

What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

350. What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.

(Continued on next question...)

Other Interview Questions