SQL & PL/SQL

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 update comma separated values

OraDev16Mar 17 2025 — edited Mar 17 2025

Hi All,

I've a string : ‘Alex-1,Bryan-2,Cindy-3’. I want to update the string as ‘Alex-1 iPhone,Alex-1 S24,Bryan-2 iPhone,Bryan-2 S24,Cindy-3 iPhone,Cindy-3 S24’. The words iPhone and S24 will be appended after each value in the string with a space.

Thanks in advance.

Added on Mar 17 2025

#plsql, #sql

1 comment

177 views