Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query
2. Set the Following Properties for the DEL Column

Type: Link
Heading: Delete
Target > Type: URL
URL: javascript:void(null);
Link Text: <span class="t-Icon fa fa-trash delete-irrow" aria-hidden="true"></span>
Link Attributes: data-id=#EXAM_ID#

Note: here EXAM_ID is primary key ( We can use ROWID also if table does not have primary key)

3. Create a Page Item (hidden) to Hold the Primary Key Column Value

Name: P152_EXAM_ID (set the name according to your page)

Type: Hidden

Value Protected: No

4. Create a Dynamic Action for the Interactive Report Delete Row Button

Name: DA_DELETE_RECORD

Event: Click
Selection Type: jQuery Selector
jQuery Selector: .delete-irrow
Event Scope: Dynamic

create below 4 true actions for above Dynamic Action.

Action: Confirm
Text: Are you sure to delete this Exam?

Action: Set Value
Set Type: JavaScript Expression
JavaScript Expression: $(this.triggeringElement).parent().data('id')
Selection Type: Item(s)
Item(s): P152_EXAM_ID

Action: Execute PL/SQL Code
PL/SQL Code: Delete from exam_details where customer_id = :P152_EXAM_ID;
Items to Submit: P152_EXAM_ID

Action: Refresh
Selection Type: Region

Region: Exams (this is the interactive report region on my page)