apex_add_interactive_grid
Add an interactive grid to an Oracle APEX page to edit database table records, including inline cell editing and row insertion.
Instructions
Add an Interactive Grid (editable spreadsheet). Supports inline editing + add row.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| add_row | No | Show "Add Row" button for inserting new records (default True). | |
| page_id | Yes | Target page ID. | |
| editable | No | Allow inline cell editing (default True). | |
| sequence | No | Region display order. | |
| sql_query | No | SELECT SQL for the IG. If omitted, uses SELECT * FROM table_name. | |
| table_name | Yes | Database table for DML operations (INSERT/UPDATE/DELETE). | |
| auth_scheme | No | Authorization scheme name. | |
| region_name | Yes | Region display name. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |