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!

Extract a substring starting with a special character

Rakesh119Jun 12 2021

I have a string
string - '!Network1 !Offer1 !CMDB3 Quality check - lt10d11'
I want to extract all the words starting with the special character '!' including the character itself, in this example they are one after another but they can any where in string.
I want the output in a comma separated string like
output - !Network1, !Offer1, !CMDB3
Thank you
Rakesh

This post has been answered by Frank Kulash on Jun 12 2021

Jump to Answer

Added on Jun 12 2021

2 comments

2,355 views

1 mention