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!

Lov with several display value

J.colOct 11 2017 — edited Oct 16 2017

Hello everyone,

I'm working on apex 5.1.1

I know this is not possible to display several value in a List of Value without plug-in.

So I tried to concatenate several value with whitespaces between the datas.

select rpad(empno, 10, ' ') || ' ' || rpad(ename, 20, ' ') || ' ' || rpad(sal, 10, ' ')

from emp

It works fine on SQLDeveloper, but not on Apex LoV.

I guess this is because the page is rendered as HTML page, and in HTML several whitespaces are replaced by only one.

I tried with rpad(empno, 10, ' ') but it doesn't work, the ' ' is displayed as text in my LoV.

I also wanted to try with CSS using white-space:pre but I don't know where and how to implemante this.

Do you know if there is any way to do what I want please ?

If no, do you know any good plug-in ? I would prefer to not use plug-in, but if I don't have any choice...

Thanks in advance.

This post has been answered by fac586 on Oct 14 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2017

Added on Oct 11 2017

#apex-5-1, #apex-discussions

10 comments

452 views