apex_add_animated_counter
Add an animated count-up number to an Oracle APEX page region. Supply a SQL query returning a single numeric value, then customize label, icon, colors, and animation.
Instructions
Add an animated counting number with label (counts up on page load).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| icon | No | Font Awesome class above the number (e.g., "fa-users", "fa-star"). | fa-tachometer |
| color | No | Accent color for the number (named or hex). | unimed |
| label | Yes | Description shown below the animated counter. | |
| prefix | No | Text prepended (e.g., "R$ "). | |
| suffix | No | Text appended to the number (e.g., "%", " pts"). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| animation | No | Animation style — "auto" or "none". When "none" the counter renders the final value immediately without count-up. | auto |
| icon_size | No | CSS font-size for the icon (default "2rem"). | 2rem |
| sql_query | Yes | SQL returning a single numeric value. Example: "SELECT COUNT(*) FROM TEA_AVALIACOES WHERE DS_STATUS='CONCLUIDA'" | |
| duration_ms | No | Animation duration in milliseconds (default 2000). | |
| number_size | No | CSS font-size for the counter number (default "2.8rem"). | 2.8rem |
| region_name | Yes | Internal region name. | |
| color_palette | No | Ignored for counters (accepts for API consistency). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |