Skip to Main Content

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!

APEX 18.2 Radiogroup/List of Values

cgravJun 5 2019 — edited Jun 20 2019

I have a SQL query that is being used to create a radiogroup/list of values.

The query looks something like this:

select value 1 || ' ' || currency value d, value 2 r

from table

Results from query:

Milk     $1.00

Toast     $3.00

Pie     $0.50

Bread     $10.00

I am trying to get the currency values to  line up nicely with each other, but I am unable to do so. I have tried using rpad and lpad.

Results I would like to see:

Milk          $1.00

Toast        $3.00

Pie           $0.50

Bread     $10.00

OR

Milk          $1.00

Toast        $3.00

Pie           $0.50

Bread       $10.00

I was just wondering if anyone else has done something similar, and got it to work.

Comments

Post Details

Added on Jun 5 2019
36 comments
1,360 views