Yes, it is possible. You can delete (or disable) the standard processes such as ApplyMRU, and replace them with your own PL/SQL processes to handle the tabular form arrays something like this: for i in 1.apex_application.g_f02.count loop update dept set dname = apex_application.g_f03(i) where deptno = apex_application.g_f02(i); end loop; However, it isn't simple and there is a fair bit you need to know to get this right, such as: • How the tabular form columns map to arrays like apex_application.g_f03 (view the page source and look for the names of the controls, e.g. • How some item types like checkboxes a work differently to others • How to perform optimistic locking to prevent lost updates There used to be a 'how to' document on apex.oracle.com that described this in detail, but I haven't been able to locate it recently.

APEX$ROW_NUM - the row number. That you want to delete child records before performing the multi row delete. Another process. Tabular Form Validations And. Learn how to build tabular forms, forms that allow multi-row insert and update operations. Forms that allow multi-row insert and update operations. Build Tabular Forms for Multi-Row. Form with a built in multiple row update process. APEX_ITEM and Dynamic. Real Love Drizabone. How can I update an Apex Tabular Form with pl/sql instead of using a multi-row update. Update Apex Tabular form with PLSQL. Oracle apex tabular form MRU process.

In this post I will explain how you can perform a custom function or procedure on multiple rows in a tabular form. In APEX, a tabular form lets you do multiple inserts or deletes using the ‘MULTI_ROW_INSERT’- and ‘MULTI_ROW_DELETE’-buttons. You can also do updates on multiple records, but you need to alter each record individually.

Doing the same update routine on a number of records, would require you to set each new value by hand, before doing the submit. Wouldn’t it be great if you can do an update on multiple selected rows in one page submit? In the following example I will show you how you can update the salary of a number of selected employees.

Elevador Manual Ford Ka there. The example consists of a tabular form on the standard ‘EMP’ table.