1.POST-TEXT-ITEM
declare
a number;
begin
if : DISP_EMPNO is not null then
select count(*) into a from emp
where empno=: DISP_EMPNO;
if a>0 then
select ename,sal into : DISP_EMPNAME,: DISP_SALARY
from emp
where empno=: DISP_EMPNO;
else
: DISP_EMPNAME:=”;
: DISP_SALARY:=”;
end if;
end if;
exception
when others then null;
end;
—————————————————————-
Watermeloen natuurlijke viagra