Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Turn Off escape special character by default for all the columns in Oracle apex

Navyashree K CDec 27 2023

Hi ,

I have a IR region and I have used APEX_ITEM API to edit and save the data dynamically.

Please find the below example

select apex_item.checkbox2(10, emp_no) select_me,
apex_item.text(20, emp_no) empno,
apex_item.text(30, ename)||apex_item.hidden(40, emp_no) ename
from emp_test;

I have 50 columns like this . Everytime the column names are changing .. For all the columns I need to turn off escape special characters (by default it will be on) but I don't want to do it every time is there any way, I can turn off escape special characters during the time of page load/ during the time of query execution.

Thanks,

Navya

Comments
Post Details
Added on Dec 27 2023
11 comments
1,269 views