declare
v_chk number;
begin
for i in 1 .. htmldb_application.g_f02.count loop /* Count total available tabular form rows where
“f02” is the name of column, Check below how to find Tabular Form column name. */
begin
select 1
into v_chk
from EMPLOYEE
where EMP_ID = htmldb_application.g_f02(i);
update EMPLOYEE
set EMP_NAME = htmldb_application.g_f03(i),
SALARY = htmldb_application.g_f04(i),
COMMISSION = htmldb_application.g_f05(i),
TOTAL_SALARY = htmldb_application.g_f06(i)
where EMP_ID = htmldb_application.g_f02(i);
exception
when no_data_found then
insert into EMPLOYEE
(EMP_NAME, SALARY, COMMISSION, TOTAL_SALARY)
values
(htmldb_application.g_f03(i),
htmldb_application.g_f04(i),
htmldb_application.g_f05(i),
htmldb_application.g_f06(i)
);
end;
end loop;
end;
Dear sir,
How to Set value in legacy Tabular form in oracle apex.
Please help me.