Display and Edit CLOB Content in Oracle APEX
In this post I will be explaining how to display and edit a CLOB content in Oracle APEX. Please follow the below steps: 1) Create a table T_EMPLOYEE CREATE TABLE T_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR2(100), DESCRIPTION CLOB ); 2) Insert the required data into the T_EMPLOYEE table. 3) Create a page in the application. (In this example Page - 5) 4) Create another page with the Page Mode as Modal Dialog (In this example Page - 6) 5) Create a region and two items in Page - 6. The Items are: P6_EMP_ID -> Type -> Hidden (Value Protected: No) P6_EMP_DESCRIPTION -> Type -> Text Area (or) Rich Text Editor 6) Now navigate back to Page - 5 and create a Region ( Type -> Interactive Report ) 7) Paste the below code in the Source -> SQL Query of the I...