answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar

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
Related questions

Example of fundamental difference between a polynomial function and an exponential function?

fundamental difference between a polynomial function and an exponential function?


Difference between normal function inline function?

gffg


What is the difference between the function of an organ and the structure of an organ?

the difference is ,a structure is where it is placed and the function is what it daos


What is the difference between the structure of an organ and the function the organ?

the difference is ,a structure is where it is placed and the function is what it daos


What is the difference between the structure of an organ and function of an organ?

the difference is ,a structure is where it is placed and the function is what it daos


What is the difference between a formula and a function?

A function has no repeated x values


What is the difference between a function and a formula?

A function has no repeated x values


What is the difference between rational function and linear function?

t is the diffrence between a rational funcrion and a linerar and polynomial function


What is the difference between a function and Procedure?

Girraf


Difference between linear consumption function and non linear consumption function?

I have no idea. However, in theory there is a difference.


What is difference between strcmpi and stricmp?

The strcmpi() function is identical to stricmp() function.


Why is the difference between xylem and phloem important in a plant?

There is structural difference between xylem and phloem. This is because their function is also different. Had there been no difference in structure, how these could have performed different function?