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.


What is the difference between structure and function and the relationship between them?

Structure refers to the physical characteristics or arrangement of components, while function refers to the purpose or role of those components. The relationship between structure and function is that the structure of an object or organism often determines its function - the way something is built or organized influences how it works or what it does. For example, the shape of a bird's wings is structured for flight, which is its function.