How to disable update for a particular column in Oracle APEX Interactive Grid

Overview

This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column.

Technologies and Tools Used

The following technologies have been used to achiev e this in oracle apex.

• Oracle Apex 21.1.

Steps

Follow the below steps to achieve this:

1) Create an Interactive Grid.

I have created an interactive grid by using the below queries.

SELECT DEPARTMENT_ID,

DEPARTMENT_NAME,

LOCATION,

MANAGER

FROM DEPARTMENTS.

2) Select the column that has to be made read only when trying to update.

• In this example, the LOCATION Column has is made read only when trying to update

3) Scroll down to the Read Only property of the column and do the changes as shown in the below screenshot.

Save and Run the page you will get the output like below.

Output:

Note:

• It is not mandatory to use 1=1. Any expression can be written. The column will be disabled if the given expression is satisfied.
• It is also not mandatory to use Type -> Expression. Other Types can also be used based in the requirement