Notes

--first testing

--testing
SELECT * FROM staff;
INSERT INTO staff VALUES (1005, 'hari','jackson', NULL,'CONTOL','10-JAN-1962');
--trigger gets fired
--message gets displayed
--hari is added with age: 57
SELECT * FROM staff;
--DROPS
DROP FUNCTION function_calc_age;
DROP TRIGGER trig_new_staff;
DROP PROCEDURE test_proc;



--second testing
--testing
SELECT * FROM staff;
--6 rows returned
UPDATE staff SET firstname = 'OBAMA' WHERE staff_id = 1001;
--trigger gets fired
---The retirement time left is 37
SELECT * FROM staff;
--staff of staff_id 1001 name gets updated from MOMO to OBAMA

--DROPS
DROP FUNCTION func_calc_retire;
DROP PROCEDURE proc_retire_time;
DROP TRIGGER trig_update_staff;


--third testing

--testing
SELECT * FROM staff;
--7 rows selected

INSERT INTO staff VALUES (1007, 'kp','oli', NULL,'CONTROL','11-FEB-1980');
--kp is added with age: 39
UPDATE staff SET firstname = 'Donald' WHERE staff_id = 1001;
--The retirement time left is 37
--Donald has 37 years left with the company.
SELECT * FROM staff;
----staff of staff_id 1001 name gets updated from OBAMA to Donald