If you want to delete multiple rows single click. Then you following the steps....
Step-1 : Create Blank Region
--> Type : Interactive Report
--> SQL Query : Use the following code
SELECT apex_item.hidden(01,EMPLOYEE_ID)||
apex_item.checkbox2(02,EMPLOYEE_ID) check1,
EMPLOYEE_ID, FULLNAME,DEPARTMENT_ID, PHONE1,IMAGE,PERMANENT_ADDRESS from EMPLOYEES
---> Select the "CHECK1" item and Use the following code in the "heading"
<input type="checkbox" id="selectUnselectAll" title="Select/UnselectAll">
--> Disable the "Escape special characters" option from the "Security option"
of the "CHECK1" item
--> Enable Users To : Unselect All
Step-2 : Select this Interactive Report
--> Static ID : partnerslRR (Copy to paste)
Step-3 : Create Dynamic Action
--> Name : Select All
--> Events : Change
--> Selection Type : jQuery Selector
--> jQuery Selector : #selectUnselectAll
--> Action : Execute JavaScript Code (copy to paste)
if ( $( '#selectUnselectAll' ).is(':checked') ) {
$('input[type=checkbox][name=f02]').attr('checked',true);
}
else {
$('input[type=checkbox][name=f02]').attr('checked',false);
}
Step-4 :
--> Create a Delete Button
Dynamic Action on Delete Button : Execute javascript code
apex.confirm("Are you sure want to Delete?","Delete");
Step-5 :
--> Create a Delete Processes
--> Type : Execute Code
--> Source Language : PL/SQL Code :
FOR I in 1..APEX_APPLICATION.G_F02.COUNT LOOP
DELETE EMPLOYEES
WHERE EMPLOYEE_ID=APEX_APPLICATION.G_F02(i);
END LOOP;
When Button Pressed : Delete