Insert into so_checkbox (id, name, favorite_flag ) values (4, 'Corporate Network Upgrade', 'N') Insert into so_checkbox (id, name, favorite_flag ) values (3, 'New Hire Training', 'N') Insert into so_checkbox (id, name, favorite_flag ) values (2, 'DevOps Best Practices', 'N') Insert into so_checkbox (id, name, favorite_flag ) values (1, 'Zero Data Loss Implementation', 'N') Id number generated by default on null as identityĬonstraint so_checkbox_id_pk primary key, I'm using apex_item.checkbox (not checkbox2) but that shouldn't matter. The code below will only update changed rows.īasic table with a flag column. In your case, you always update all rows. That way you can optimize your pl/sql block to only update the rows that actually need changing. You can get around that by adding additional apex_item.hidden columns and using those in your pl/sql process to update. The issue with apex_item.checkbox is that it only has a value when checked, so you don't have enough info to know which rows have changed from checked to unchecked or the other way around. WHERE LRG_NAME IN APEX_UTIL.TABLE_TO_STRING(APEX_APPLICATION.G_F01) I tried using APEX_UTIL.TABLE_TO_STRING but it didn't work for me: UPDATE MY_TABLE SET FLAG=1 How can I run one query that can update all rows at once? Step2 above takes a lot of time if the list is long. WHERE LRG_NAME=APEX_APPLICATION.G_F01(i) Loop over APEX_APPLICATION.G_F01 and set FLAG=1.This means I can update the B1,B2,B3 rows as they are present in the array but not A1,A2. I learned that APEX_APPLICATION.G_F01 will only contain the values for rows where checkbox was checked. changed 3 rows (B1,B2,B3) from unchecked to checked.changed 2 rows (A1, A2) from checked to unchecked.After which I need to update the FLAG column in DB accordingly. I want to allow the user to select or deselect any rows. P_attributes => DECODE(flag,1,'CHECKED', 'null')) In the report, the checkbox for each row is ticked if FLAG=1 APEX_ITEM.CHECKBOX2( Say it renders a table MY_TABLE This table contains a FLAG column whose value is either 0 or 1 I am using checkboxes in an interactive report in my apex app.

Apex update