| condition in triggers [message #253965] |
Wed, 25 July 2007 06:58  |
singhabm
Messages: 4
Registered: July 2007
Location: India
|
Junior Member |
|
|
Hi All,
I just want to ask that is there any way to put conditions in trigger that it should fire only when the condition is satisfied?
Suppose I have an Employee table
columns are Empname, Empjob, salary and Deptno.
I want a insert trigger to be fired only when i insert a row in Employee table with job as manager
and if i insert row with job as Clerk or any job other than Manager then that trigger should not fire.
looking forward for your reply..
Thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
