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"
--• Business Solutions: --• Enterprise ERP, Database Management & IT Infrastructure --• AI, Cloud
Subscribe to:
Post Comments (Atom)
https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure th...
No comments:
Post a Comment