Could anyone help me in writing triggers? Plzz

[jenipriya]

I have an employee table which contains the fields EmpId,EmpName,DeptId,DateOfJoin,Sal,Addr

how to write a trigger for this table such that

whenever a new employee is added to the employee table one row should be added in the Finance table(ID,SAL) for that employee and update Department table(DeptId,DeptName,NoOfEmployees)

such that Department.NoOfEmployees = Department.NoOfEmployees + 1

and whenever an employee s deleted the reverse operation shud take place

and also Whenever the salary field is updated the difference should be updated in the finance table.

Please tell me how to use Insert,Update Delete triggers for this table?

[debasisdas]

Since you had posted a question in Article section it it being moved to Oracle forum.

[debasisdas]

create an after INSERT or DELETE trigger
if inserting then
insert the new id and sa l into finance table.
also do the same on department table and update the no foemployees by the total numbers of records in the table.

do the reverse in delete event.

if u still have any doubts do post back next time with the code you have tried .

[jenipriya]

Actually i m a fresher and nevr tried triggers cud u giv an example so that i can try and get back to u with the code.. the table stryctures are

Employee (EmpID, EmpName,DeptID DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)

[debasisdas]

Please find the details regarding triggers here.

Hope that helps you in understanding triggers better.

[jenipriya]

1. CREATE OR REPLACE TRIGGER mytrig
2. After INSERT ON Employee
3. FOR each ROW
4. BEGIN
5. IF inserting THEN
6. INSERT INTO Finance VALUES(:NEW.empno,:NEW.sal);
7. UPDATE INTO Department SET Department.NoOfEmployees = Department.NoOfEmployees + 1;
8. END IF;
9. END;

Wil dis query work? plz correct if der s anythng wrong...