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;
—————————————————————-

2.POST-CHANGE

select ename,sal into : D_NAME,:D_SAL
from emp
where empno=: D_EMPNO;
—————————————————————
3.POST-QUERY
if :item_id is not null then
select item_name into : item_name from item_info a
where item_id=: item_id;
end if;
————————————————————–
4.WHEN-NEW-FORM-INSTANCE
: SALES_DATE:=sysdate;
————————————————————–

Suggested Posts:

Leave a Reply