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!

Replace values with image using DECODE

Vincent van LeijdenMay 16 2014 — edited May 17 2014

I am struggeling to replace values in a table with images using DECODE as shown here"https://apex.oracle.com/pls/otn/f?p=21195:1:0:::::.

The query in itself is no problem and works fine:

SELECT JOB_NAME Job, DECODE(ENABLED, 'TRUE', '<img src="/i/orcl/up.gif">', 'FALSE', '<img src="/i/orcl/down.gif">') AS Status

FROM USER_SCHEDULER_JOBS

Easy peasy, but...

Somewhere along the line the bracket < and > are replaced with < and > and the quotes with ".

As a result, the browser literally shows <img src="/i/orcl/up.gif"> and no image.

What a I doing wrong?

This post has been answered by fac586 on May 16 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2014

Added on May 16 2014

#apex-discussions

2 comments

1,439 views