Pupdepartments.ac.in

Write a trigger total_salary to maintain a derived column totsal that stores the total salary of all members in a department. Create an INSTEAD_OF trigger on view V1 which contains columns DNAME, ENAME and SALARY from tables Dept and Emp joined on the basis of DEPTNO. ................
................