Oracle APEX - How to show Images in Oracle APEX Interactive Report

 In this post, I can explain how to show images in Oracle APEX interactive Report.

Table Script

CREATE TABLE BLOB_IMAGES (BI_IMG_DESC VARCHAR2(100),   BI_IMG BLOB,                                BI_MIME_TYPE VARCHAR2(250),   BI_FILE_NAME VARCHAR2(250));

Report Query

SELECT ROWID,
       bi_img_desc,
       DECODE(NVL(DBMS_LOB.GETLENGTH(bi_img), 0), 0, NULL,
       '<img alt="'||APEX_ESCAPE.HTML_ATTRIBUTE(bi_img_desc)||
       '" src = "'||APEX_UTIL.GET_BLOB_FILE_SRC('P11_BI_IMG', ROWID)||

       '" height = "50" width = "50" />') bi_img,
       bi_mime_type,
       bi_file_name
  FROM blob_images

* P11_BI_IMG - Form Page column name

APEX Workings

Step 1:

Create a Page with the type of Report with form

Step 2:

Change Report query which is mentioned above

Step 3:

Run the report and add image and view

https://youtu.be/4HpNXB-Sf5Y

Thanks & Regards

R. Kalaiyarasan

+91 9944809554