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!

Where to change the colon stored for multiple value list?

John like many othersAug 10 2020 — edited Aug 12 2020

Hello

I have companies (value) with description (display). I therefore have an SQL representing them as Popup LOV which is working fine. Now the user should be able to select more than once company (multiple value). This is also working fine. The problem is that Apex (19.2) is using the COLON sign as a separator in the DB but I would like to have it saved with COMA as separator. I can choose that but only for displaying purposes not for storing it the same way. Same problem on using Checkbox instead of Popup LOV. I just can't imagine that Apex is not thinking further and not to allow the developer to decide which separator in the DB will be used.

Can someone tell me where I can switch the colon separator to the wanted separator used to store in DB?

Thank you

Comments
Post Details
Added on Aug 10 2020
5 comments
1,844 views