Daily Archives: July 27, 2013

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