Action initiation after inserting a record in a table?

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.

asked Dec 14, 2009 at 03:21 PM in Default

dbkid
131 ● 9 ● 10 ● 14

(comments are locked)

1 answer:

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.

answered Dec 14, 2009 at 04:12 PM

Dean Langford
111 ● 2 ● 2

Thanks a lot Dean Langford. Triggers solved my problem.

Dec 14, 2009 at 04:54 PM dbkid

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

asked: Dec 14, 2009 at 03:21 PM

Seen: 811 times

Last Updated: Dec 14, 2009 at 03:21 PM