need help in rewriting sql into plsql
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.
delete from HRW_HEALTH_PLAN_DEPENDENTS where
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');
delete from HRW_INSURANCE_BENEFICIARIES where
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');
delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';
"High Salaries = Happiness = Project Success."