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.