You have defined a REST Data Source with ORDS as the REST Data Source Type. The Source is being used as source for an editable Interactive Grid. When a user updates an employee record in this Interactive Grid, which operation is performed on the Database?

APEX and Oracle REST Data Services (ORDS) follow standard RESTful principles for mapping database operations to HTTP methods. When a user modifies a row in an editable Interactive Grid that is based on an ORDS REST source, APEX sends an update request to the REST endpoint for that specific record. The standard HTTP method for updating an existing resource is PUT. The body of the PUT request will contain the new data for the columns that were modified in the grid.

A. The POST method is used to create a new resource. In the context of an editable grid, this method would be invoked when a user adds and saves a new row.
B. The GET method is used for data retrieval. APEX uses GET requests to fetch the data initially required to populate the Interactive Grid.

1. Oracle REST Data Services Documentation, 23.4, Section 5.3, "About REST-Enabled Tables, Views, and PL/SQL." The documentation specifies the mapping: "PUT: Update a row in the table or view."

2. Oracle APEX App Builder User's Guide, Release 23.2, Section 16.3.1, "About REST Data Sources." This section explains how APEX components, including Interactive Grids, utilize REST data sources and map DML operations (Insert, Update, Delete) to corresponding HTTP methods (POST, PUT, DELETE).