By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- sample data
with t (overview) as (
select '<div><p>Some entities: & ' < > to be handled </p></div>'
from dual
)
select REGEXP_REPLACE(overview, '<.+?>') as result1,
utl_i18n.unescape_reference(regexp_replace(overview, '<.+?>')) as result2
from t
| RESULT1 | RESULT2 |
|---|---|
| Some entities: & ' < > to be handled | Some entities: & ' < > to be handled |