apex_add_scatter_plot
Build a scatter plot in Oracle APEX by running a SQL query that returns numeric X and Y values, with an optional label column for data-point tooltips.
Instructions
Add a scatter plot. SQL: X_VALUE, Y_VALUE, optional LABEL.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels. | |
| labels | No | Optional dict to override labels. Supported key: ``"series"`` (series legend label). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| x_column | No | Column for X-axis numeric values. | X |
| y_column | No | Column for Y-axis numeric values. | Y |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| sql_query | Yes | SQL returning x_column, y_column, and label_column. Example: "SELECT DS_NOME LABEL, MONTHS_BETWEEN(SYSDATE, DT_NASCIMENTO)/12 X, NR_PCT_TOTAL Y FROM TEA_BENEFICIARIOS b JOIN TEA_AVALIACOES a USING(ID_BENEFICIARIO) WHERE DS_STATUS = 'CONCLUIDA'" | |
| region_name | Yes | Region display name. | |
| series_name | No | Legend series name. | Correlation |
| label_column | No | Column for data-point tooltip labels. | LABEL |
| x_axis_title | No | X-axis label. | |
| y_axis_title | No | Y-axis label. | |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| color_palette | No | List of hex colours, a named palette string, or None. | |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |