apex_generate_from_schema
Build complete Oracle APEX apps from table names: generates CRUD pages, a dashboard, and navigation automatically.
Instructions
Generate a complete app from a list of tables: CRUD pages + dashboard + navigation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | Yes | List of table names to generate CRUDs for. Example: ["EMPLOYEES", "DEPARTMENTS", "PROJECTS"] | |
| nav_icon_map | No | Dict mapping table name to Font Awesome icon class. Example: {"EMPLOYEES": "fa-users", "DEPARTMENTS": "fa-building"} Defaults to "fa-table" for unmapped tables. | |
| start_page_id | No | First page ID for the first CRUD list (default 10). Pages are allocated: 10/11, 12/13, 14/15... | |
| include_dashboard | No | Generate a dashboard page with record counts (default True). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |