SQL & PL/SQL

Hi

I need to remove strings between the signs <> including the signs themselves

For example

<%text%> My receipt image text <%someothertext%>

the expected results would be

My receipt image tex

right now I am using the replace function as follow

SELECT REPLACE(REPLACE(REPLACE(

      (REPLACE(

      (REPLACE(

      (REPLACE(

      (REPLACE(

      ((REPLACE(

      (REPLACE( (SUBSTR(r.text, 1, instr(r.text, '<%RECEIPTCUT%>')-1)),'<%RECEIPTSELECT%>',''))

      ,'<%LOGO%>','')))

      ,'<%BOLD%>',''))

      ,'<%/BOLD%>',''))

      ,'<%BIG%>',''))

      ,'<%/BIG%>',''))

      ,'<%REPRINT_R%>','')

      ,'<%/BARCODE%>','')

      ,'<%BARCODE%>','') RECEIPT

FROM RECEIPTIMAGE R

this method works but it gets messy and the problem is when the receipt format changes I need to fix it manually.

The pattern is always like this:

<%TEXT%>

where TEXT changes but not the <% %>

Is there a way to find the pattern and remove whats inside including the signs..

Thanks

Youssef