|
I am having a table EMPLOYEE. In that, we have list of all employees in that table. We have Emp No, Name, Gender, Salary, Joining date , Valid_Employee columns. When there is a female employee entry in a table, I want to do set of actions. Such as insertion of another entry in another table. Is there any way we can acheive this in oracle? I am using oracle 10g.
(comments are locked)
|
|
You want to create a trigger on the table. You can either have the trigger only fire if the employee is a female using the WHEN clause, or use an IF...THEN in the trigger body. Thanks a lot Dean Langford. Triggers solved my problem.
Dec 14 '09 at 04:54 PM
dbkid
(comments are locked)
|
Your answer
