Hi,
I have a string like this: ABC_STRING_DEF_GHI_JKL. Where the "STRING" part is constant.
I am trying to get its corresponding regex pattern.
Something like
%_STRING_%_%_%
So far I managed to get to this point:
SELECT 1 FROM DUAL WHERE REGEXP_LIKE('abc_STRING_def_ghi_jkl', '(^(\w[^_])+)_STRING_([^_]+)_([^_]+)_([^_]+)$');
It's not really working, so if you have any idea, please help!
Thanks,
Ender