Enabling APEX to Operate MySQL as if it were Oracle tables

kenny Public · Mar 6 2025

Idea Summary
As we all know, Oracle APEX is based on Oracle database, you can easily insert, update, delete and query data of tables in Oracle database. However, in reality, there are many applications based on MySQL database. If APEX could be as simple as operating Oracle tables to operate MySQL tables (CRUD), the work scenarios of APEX application will go to a new level.

Use Case
Make APEX be applied to MySQL-based application development scenarios.

Preferred Solution (Optional)
Scan through ORDS and automatically generate RESTful APIs based on MySQL database tables that support CRUD operations. Then developers are able to leverage these APIs declaratively in APEX.

This idea is open.

Comments

carsten.czarski APEX Team OP 5 months ago
APEX provides working with MySQL databases using REST Enabled SQL since version 22.1.
- https://docs.oracle.com/en/database/oracle/apex/24.1/htmdb/creating-rest-enabled-sql-example-mysql.html
- https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.1/orddg/rest-enabled-sql-service.html#GUID-3B463D97-4F7C-4B9B-8E56-1ED11E17960F
This support is currently limited to “read only”, i.e. you can create reports, charts, calendars and even form pages on MySQL sources. However, declarative DML is not possible yet - but that gap can be closed using the APEX_WEB_SERVICE package or REST Data Sources.

Did you try these features out already?

10 Voters

Enabling APEX to Operate MySQL as if it were Oracle tables

Feature

Comments

Comments