How to use regular expressions in one statement on a column

Hi team,

I have a column, which stores long text description with special characters of html like <> , &amp; ,&lt; , &gt; ,&amp; ,&quot; .

for example- 'jack &amp; jill &lt; eliminate this txt &gt; , went up the &quot; hill &quot; to fetch a pail of water , jack fell down<oh no --eliminate> and broke his leg.

jack & jill , went up the "hill" to fetch a pail of water, jack fell down and broke his leg.

so

&lt; should be replaced with <
&gt; should be replaced with >
and text between this brackets should be erased.

replace &quot ; with "
&amp; with &

I tried like this -
select replace(
replace(
replace(
replace(
regexp_replace( 'jack &amp; jill &lt; eliminate this txt &gt; , went up the &quot; hill &quot; to fetch a pail of water, jack fell down<oh no --eliminate> and broke his leg.','<.*?>'),
'&lt;','<'),
'&gt;','>'),
'&amp;','&'),
'&quot;',' " ') replace_tryout from dual;

but it is not working as I want.


while running query it is asking for values of &amp, &lt, &gt ,&quot and after I input it all the times with respective values like -&,<,>,"

this code returned below output..

jack & jill ; , went up the " hill " to fetch a pail of water, jack fell down and broke his leg.
I want to remove that extra semicolon.

is there any alternative for this code, becoz I am using it(oracle DB as backend) in sample cube , and it is taking very long time to process.

please help.