I know this has probably been asked and answered but I couldn't find an exact thread to help me ..
can this be done in a single regexp_replace (i.e. not as the nested example I have):
with t as (
select '/p <p><table cellspacing="0" cellpadding="2" width="931" border="0"><tbody>Hello World' b from dual
)
select regexp_replace(regexp_replace(b,'<.*?>'), '/p')
from t
R
------------
Hello World
basically I want to replace/remove any html/xml tags as well as a second pattern, '/p' in this case.
What is the syntax to supply multiple patterns in a single regexp_replace expression, or is the way I have it correct?
thanks