13.1.3 Using a REST-Enabled SQL Service

Once you've created a REST-Enabled SQL Service reference at workspace level, you can use it almost anywhere you can configure a data source.

You can use a REST-Enabled SQL Service reference in any APEX region, List of Values, or other dynamic list use cases. You do this by choosing a source Location of REST-Enabled SQL. For example, as shown below, the Employees Interactive Report region uses the EMP table in the Remote Oracle Database defined above.

Figure 13-4 Using a Table in a Remote Database with REST-Enabled SQL

Description of "Figure 13-4 Using a Table in a Remote Database with REST-Enabled SQL"

All the Source > Type options are available against a remote Oracle database, so you can also use a SQL Statement and Function Body Returning SQL Query as well. For a remote Oracle database, all read and write operations are supported. In contrast, remote MySQL databases are read-only. While you can display MySQL data in any APEX region including Form and Interactive Grid, the latter two regions' automatic DML page processes are not yet supported.