Oracle CLOB field Strip HTML tags

Remove HTML tags with regular expressions

[HTML]View PlainCopy

1. Select Regexp_replace (Content, '</?[ ^>]*>|nbsp;|& ', ') content from T_test_content_config T
2. ORDER BY status_date Desc;

Original CLOB content:

 

<p><spanstyle= "font-family: the song Body;" > "XXX Company" you have a XX has not been collected! Use </span><spanstyle= "Font-family:calibri;" >8g</span><spanstyle= "font-family: the song Body;" > Set </span><spanstyle= "Font-family:calibri;" >18</span><spanstyle= "font-family: the song Body;" > can receive </span><spanstyle= "FONT-FAMILY:CALIBRI;" >50m</span><spanstyle= "font-family: the song Body;" > Broadband, </span><span style= "Font-family:calibri;" >18</span><span style= "font-family: the song Body;" > can receive </span><span style= "FONT-FAMILY:CALIBRI;" >10m</span><span style= "font-family: the song Body;" > Broadband </span><span style= "Font-family:calibri;" >+</span><span style= "font-family: the song Body;" > TV set-top box. More offers </span><span style= "Font-family:calibri;" >30012</span><span style= "font-family: the song Body;" > or broadband reservation phone </span><span style= "FONT-FAMILY:CALIBRI;" >158******</span><span style= "font-family: the song Body;" Whether the consultation meets the eligibility criteria. </span><aname= "_goback" &GT;&LT;/a></p><p>&nbsp;</p>

After conversion:

"XXX Company" you have a XX has not been collected! Use 8G package 18 to receive 50M broadband, 18 yuan to receive 10M Broadband + TV set-top box. For more offers, see the 30012 or broadband reservation telephone 158****** For more information on eligibility.

Oracle CLOB field Strip HTML tags