answersLogoWhite

0

triggers are fired automatically but we need to call functions. Triggers can b fired on update, insert command.

For example if there is field of phoneNumber. We need to validate phoneNumber on insert and update as characters are not allowed. So to VALIDATE phoneNumber there will be a function. And this will be called in a trigger so that if any updation or insertion is done it will automatically check phoneNumber.

Hope this is easy to understand

amit_0486@Yahoo.com

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

ReneRene
Change my mind. I dare you.
Chat with Rene
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine
BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake

Add your answer:

Earn +20 pts
Q: What is the difference between trigger and function?
Write your answer...
Submit
Still have questions?
magnify glass
imp