Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to display image via 'display image' item, using SQL?

marian_manMar 1 2017 — edited Mar 3 2017

Hi

how can I display image via 'display image' item?

the image is stored as BLOB in my database table, that can be retrieved as

SELECT PHOTO FROM EMPLOYEES WHERE ID_EMPLOYEE = ...

but this does not seem to work , or I don't know where to put this SQL query?,

because there are two available fields: in SETTINGS | Based on SQL statement,

or in SOURCE | SQL Query (return single value) ?

(see attached)

photo1.png

photo2.png

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 31 2017
Added on Mar 1 2017
#apex-discussions, #blob, #item
6 comments
3,667 views