This content has been marked as final. Show 4 replies
now i've created a new region called update_all_region with two text field items.
CREATE TABLE EMP ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10 BYTE), JOB VARCHAR2(9 BYTE), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2)) ALTER TABLE EMP ADD ( PRIMARY KEY (EMPNO)
lets take a look at the scenario :
p30_sal p30_deptno and an update_all button .
i want that all the rows which appears in the report (total = 100) will be update.
p30_sal : 90000 p30_deptno : 30 and pressing the update_all button .
begin FOR i IN 1..APEX_APPLICATION.G_F02.COUNT LOOP update emp set salary = :p30_salary , deptno= :p30_deptno where employee_id = apex_application.g_f02(i); END LOOP; commit; end;