Skip to Main Content

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!

replace specific word oracle

helooSep 24 2019 — edited Sep 30 2019

data

----------------------------------------

4_ABCDFFFF.02_XXX_0
0_dfeddfdfdfdfsd.02_feggx_999

can can i replace the word between the first and second underscore with "XYZ" by oracle 12c

how to detect the first and second underscore to replace by sql

expected output

---------------------------------------

4_XYZ_XXX_0
0_ZYZ_feggx_999

Added on Sep 24 2019

29 comments

1,051 views