Dear Friends
We want to insert data from A table to B table. How it will be written in Oracle Apex Forms.
In the form 12c i was writing the code in the following way, now in apex how to write.
Create Procedure Test1 as
Declare
Cursor a1 is select empno,name from employee;
begin
delete from test1;
commit;
for i in a1
loop
insert into test1(empno,name)
values (i.empno,i.name);
end loop;
COMMIT_FORM;
end;
sanjay