Wednesday, January 9, 2019

how many way image show in oracle apex 18.2 report

1. size wise image report

select "ROWID",
"ID",
'<img src="'||apex_util.GET_BLOB_FILE_SRC('P21_IMAGE',ROWID)
 ||'" height="100px" width="100px"' "IMAGE",
"MIMETYPE",
"FILENAME",
"LASTUPDATE"
from "#OWNER#"."TEST_IMAGE"

2. long report orginal

select "ROWID",
"ID",
'<img src="'||APEX_UTIL.GET_BLOB_FILE_SRC('P21_IMAGE',ROWID)||'"/>'   "IMAGE",
"MIMETYPE",
"FILENAME",
"LASTUPDATE"
from "#OWNER#"."TEST_IMAGE"

3. default report image IR

select "ROWID",
"ID",
dbms_lob.getlength("IMAGE") "IMAGE",
"MIMETYPE",
"FILENAME",
"LASTUPDATE"
from "#OWNER#"."TEST_IMAGE"

4.

select "ROWID",
"ID",

decode(nvl(dbms_lob.getlength(IMAGE),0),0,null,
'<img alt="'||apex_escape.html_attribute(ID)||'" title="'||apex_escape.html_attribute(ID)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;"'
  ||'src="'||apex_util.get_blob_file_src('P3_IMAGE',ROWID)||'" height="150" width="200" />')
"IMAGE",

"MIMETYPE",
"FILENAME",
"LASTUPDATE"
from "#OWNER#"."TEST_IMAGE"


5.  Circle / Squre Image
/*
decode(nvl(dbms_lob.getlength(PIC),0),0,null,
'<img alt="'||apex_escape.html_attribute(EMP_ID)||'" title="'||apex_escape.html_attribute(EMP_ID)
||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;"'
  ||'src="'||apex_util.get_blob_file_src('P16_PIC',ROWID)||'" height="50" width="60" />')
"IMAGE"  --square image
*/
decode(nvl(dbms_lob.getlength(PIC),0),0,null,
'<img alt="'||apex_escape.html_attribute(EMP_ID)||'" title="'||apex_escape.html_attribute(EMP_ID)
||'" style="border: 4px solid #CCC; -moz-border-radius: 50%; -webkit-border-radius: 50%;"'
  ||'src="'||apex_util.get_blob_file_src('P16_PIC',ROWID)||'" height="50" width="60" />')
"IMAGE"



No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...