need help in rewriting sql into plsql
Hello,
I wanted to take the following sql and put it in a plsql precedure so that a user can just execute that procedure when ever they wanted to do the following operation.
spool delete_one_employee
delete from HRW_HEALTH_PLAN_DEPENDENTS where
health_plan_key in
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');
delete from HRW_INSURANCE_BENEFICIARIES where
insurance_key in
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');
delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';
spool off
thanks
Jigar
"High Salaries = Happiness = Project Success."