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!

REGEXP Extract a word from any place in a string

user13117585Aug 19 2020 — edited Aug 24 2020

Hello everyone,

I have a set of data like this :

Hello MSG_WORLD. Life is great

THis is anothe [MSG_MESSAGE] and it's there

MSG_START and this one start the string.

Is there any way to extract the words starting with MSG from each example with one REGEXP?

Regards,

Added on Aug 19 2020

#11g, #oracle

12 comments

2,557 views