SELECT replace(replace(regexp_replace(name,'</?[^>]*>'),'nbsp;'),'&') FROM scott.t
SELECT regexp_replace(name,'<[^>]*>|[nbsp;&]') FROM scott.t
SELECT replace(replace(regexp_replace(name,'</?[^>]*>'),'nbsp;'),'&') FROM scott.t
SELECT regexp_replace(name,'<[^>]*>|[nbsp;&]') FROM scott.t