A reader, September 21, 2017 - 4:08 pm UTC
Following query worked for me.
select replace(tag,'#','') as tag, from(
with texttab as
(
SELECT
ROOT_CAUSE as text
from cust_bug_data where ROOT_CAUSE is not NULL
)
SELECT regexp_substr(text,'\#[a-z0-9_]+',1,level,'i') as tag
FROM texttab
CONNECT BY regexp_substr(text,'\#[a-z0-9_]+',1,level,'i') IS NOT NULL) t
September 21, 2017 - 4:13 pm UTC
Glad you got this working.