IG Manually processing data
Posted: Sun Nov 20, 2022 6:37 am
You might need to process each row of IG manually so the following code will be executed as a loop for each changed row,
Video related to IG
Code: Select all
begin
case :APEX$ROW_STATUS
when 'I' then
insert into emp ( empno, ename, deptno )
values ( :EMPNO, :ENAME, :DEPTNO )
returning rowid into :ROWID;
when 'U' then
update emp
set ename = :ENAME,
deptno = :DEPTNO
where rowid = :ROWID;
when 'D' then
delete emp
where rowid = :ROWID;
end case;
end;