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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

88 views

SQL & PL/SQL

How to update comma separated values

Comments

Post Details