I updated a page in Oracle Application Express by adding a column for Remarks after an employee made a change to a drop-down. The condition is based on any changes made to a drop-down box called “Non-Statistic”. The value of the drop-down is either “Statistic” or “Non-Statistic” . If the user changes the Non-Statistic to a different value (let’s say STATISTIC), he/she must enter the reason for changing the value. If the user does not change the value, then no action is needed.
Given that I am new to PL/SQL, I am having hard time coding this. Any help is highly appreciated.