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 use APEX_STRING.JOIN()

Joe RJul 28 2020 — edited Jul 29 2020

Version: Application Express 19.2.0.00.18

Hello,

I'm having a horrible to trying to the APEX_STRING.JOIN to work for a multi-value select list.

Since the values returned are in a colon delimited string I'm SPLITing the values and inserting the values into an XREF (cross reference) table. So each value has a separate row.

So when retrieving the values from the XREF table I need to combine them back into a colon delimited list so the LOV displays the descriptions right?

Everything I'm seeing is using the SPLIT and I'm not finding anything on the JOIN.

I've also tried the APEX_STRING.TABLE_TO_STRING with no luck.

How the heck do you use the JOIN in the query?

Thanks,

Joe

This post has been answered by fac586 on Jul 28 2020

Jump to Answer

Added on Jul 28 2020

#apex-discussions

6 comments

1,952 views