Code for sequential serial provide:
(PRE-INSERT)
select nvl (max(employee_id),0)+1 into :employee_id from employee;
——————————————————————–
POST Query
if : department_id is not null then

select department_name
into : disp_department
from hr_department
where id=: department_id;
end if;

Suggested Posts:

Leave a Reply