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!

Convert a string to initials

girishkaleApr 28 2020 — edited Apr 30 2020

Hello All,

I'm looking for a SQL to convert a string separated by an underscore ("_") to pull one character after each underscore as if I'm pulling out initials.

e.g.

string "THIS_HAPPENED_IN_SPACE", i want to convert this string to "THIS" picking one character after each underscore.

Thanks in advance for your help!

Best Regards,

Girish

This post has been answered by mathguy on Apr 28 2020

Jump to Answer

Added on Apr 28 2020

19 comments

1,056 views