Step 1:
Create Classic / Interactive Report.
Add Delete Column.
'<a href="'||'javascript:pageItem1(' || APEX_ESCAPE.JS_LITERAL (PRODUCT_ID) || ')"><span class="edit-action" style=" letter-spacing: .3px; display: inline-block;padding: 0.4rem 0.66666667rem;font-size: 89%;line-height: 1;padding-right: 0.6em;padding-left: 0.6em;
border-radius: 10rem; background-image: linear-gradient(310deg,#ff0000,#c70000); color: #ffffff;font-weight: bold;border: 2px solid #fffde7;
box-shadow: 0 5px 10px -3px rgb(0 0 0 / 23%), 0 6px 10px -5px rgb(0 0 0 / 25%);">'||'Delete'||'</span></a>' AS DEL
Step 2:
Create Items: P18_P_ID
Create Dynamic Action.
Event: Change
True Action: Confirm
Message: Are you sure this delete!!
True Action: Execute Server-Side Code
--> PLSQL Code:
BEGIN
Delete from PRODUCT
where PRODUCT_ID=:P18_P_ID;
END;
--> Items to Submit: :P18_P_ID
True Action: Refresh
Selection Type: Region
Step 3:
Function and Global Variable Declaration:
function pageItem1(DEL){$s('P18_P_ID', DEL)}
var htmldb_delete_message='"DELETE_CONFIRM_MSG"';