Adjust image size in interactive/classic report – Oracle APEX
Image uploading is a basic requirement in many application.
When a user is uploading an image into database using APEX application, he is not checking the height and with of that image.
That’s why when developer trying to display that image in any classic or interactive report he need to adjust the size for a better look and feel of that report.
But resizing the image in APEX application is also achievable adding some css code in your sql query.
Please check below screenshot how the css code has been written inside sql query to resize image in intercative/classic report in Oracle APEX application.
Copy and paste the below code inside your sql statement.
decode(nvl(dbms_lob.getlength(item_image),0),0,null,
‘<img style=”border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius:
4px;” ‘||
‘src=”‘||
apex_util.get_blob_file_src(‘P904_ITEM_IMAGE’,item_id)||
‘” height=”75″ width=”75″ alt=”Product Image” title=”Product Image” />’) detail_img,
Change the “P904_ITEM_IMAGE” as per your form page item.
Save and run the query to see the changes.
Feel free to add your query for any kind of support.
