Smart Row Delete - Oracle APEX Plugin

A powerful and easy-to-use Oracle APEX Dynamic Action plugin that enables seamless row deletion in Interactive Reports and Classic Reports — with customizable confirmation dialogs, success/error messages, and smooth animations.

---

🚀 Features

• Easy Integration: Simple setup with minimal configuration
• Interactive & Classic Reports: Works with both report types
• Composite Primary Keys: Supports multiple primary key columns
• Customizable Messages: Configure success, error, and confirmation messages
• Visual Feedback: Smooth animations and loading indicators
• Automatic Refresh: Auto-refreshes the region after deletion
• Security: Built-in SQL injection prevention
• No Page Reload: AJAX-based deletion without full page refresh
• Flexible Icon Support: Use any Font Awesome icon for the delete action

---

🎬 Demo

🔗 View Demo on LinkedIn

---

🧩 Requirements

• Oracle APEX 23.1 or higher

---

⚙️ Installation

Method 1: Import Plugin File

1. Download the latest plugin file from Releases
2. Navigate to Shared Components → Plugins
3. Click Import and select the downloaded .sql file
4. Follow the import wizard to complete installation

---

🏁 Quick Start

Step 1: Prepare Your Report Query

Add a delete action column to your SQL query:

SELECT   
    EMP_ID,  
    EMP_NAME,  
    DEPARTMENT,  
    SALARY,  
    '<span class="delete-icon fa fa-trash-o" data-emp_id="' || EMP_ID || '"></span>' AS DELETE_ACTION  
FROM EMPLOYEES;

For Composite Primary Keys:

SELECT   
    CPT_ID,  
    TEST_ID,  
    PARAMETER_ID,  
    ACTIVE,  
    '<span class="delete-icon fa fa-trash-o"   
           data-cpt_id="' || CPT_ID || '"   
           data-test_id="' || TEST_ID || '"   
           data-parameter_id="' || PARAMETER_ID || '"></span>' AS DELETE_ACTION  
FROM COMMENTS_TEST_PARAMETER;

---

Step 2: Configure Report Column

1. Edit the DELETE_ACTION column
2. Set Type → Display as Text
3. Set Escape Special Characters → No

---

Step 3: Create Dynamic Action

1. Create a new Dynamic Action on Page Load
2. Optionally, set Event Scope → Dynamic
3. Action: Select Smart Row Delete from the plugin list

Configure Plugin Settings:

• Table Name: EMPLOYEES (or your table name)
• Primary Key Column(s): EMP_ID (use colon : for multiple: CPT_ID:TEST_ID:PARAMETER_ID)
• Region Static ID: Your report region's static ID (e.g., employee_report)
• Success Message: Record deleted successfully (optional)
• Error Message: Error deleting record (optional)
• Confirmation Message: Are you sure you want to delete this record? (optional)
• Show Confirmation: Yes (optional)
• Delete Icon Class: fa-trash-o (default, optional)
• Icon CSS Class: delete-icon (default, optional)

---

Step 4: Set Region Static ID

Ensure your report region has a Static ID (e.g., employee_report) so the plugin can reference it correctly.

---

⭐ Star

If you find this plugin useful, please consider giving it a star ⭐
It helps others discover the project!

---

Made with ❤️ for the Oracle APEX Community