Digvijaysinh Virpura's Blog

  Upload Blob (Image) in database table manually in Oracle APEX  This blog demonstrate the steps to insert or store image into database table using manual process in Oracle APEX. Step1: We Need a table which have a blog column. So we have created a table DEMO_PRODUCT_INFO. CREATE TABLE "DEMO_PRODUCT_INFO" (            "PRODUCT_ID" NUMBER NOT NULL ENABLE, "PRODUCT_NAME" VARCHAR2(50), "PRODUCT_DESCRIPTION" VARCHAR2(2000), "CATEGORY" VARCHAR2(30), "PRODUCT_AVAIL" VARCHAR2(1), "LIST_PRICE" NUMBER(8,2), "PRODUCT_IMAGE" BLOB) Step2: Now Create a Blank Page in Oracle APEX and Add Items on the Page as shown below.       Step3: Now select P23_PRODUCT_IMAGE and select type as File Browse and Storage Type as Table APEX_APPLICATION.. Step4: Now create a process and add following code in it and execute it on the click event of a button. declare Image BLOB; begin select blob_content into Image fr...

 This blog will demonstrate steps to display column value with different color based on calculations. Following is output of what we want to achieve. Step1: Create an Interactive Report based on SQL Query.I have used following query.You can use your own as per your requirement. select     EMPNO,     ENAME,     JOB,     DEPTNO,     SAL,     case when SAL < 3000 then 'red'         when SAL between 1000 and 2000 then 'blue'         when SAL > 3000 then 'green'     end text_color from EMP EMP     Step2: Now go to Columns under Report and select Text_Color.   Step3: Now set Type = Hidden Column     Step4:  Now you have to set following code in each column under Column Formatting (HTML Expression)   <span style="color:#TEXT_COLOR#;font-weight:bold;">#SAL#</span>...