<div>
<div class="content wysiwyg-content">
Hi All, 
 
While writing a report, I’m running into a road block when trying to extract data from a LONG datatype column that is stored with HTML tags. &nbsp; I tried REGEXP_REPLACE but it does not accept LONG datatype column. 
 
Here is an example of corrupted data: 
 
1 record …. 
&lt;html&gt;hard horn buttons&lt;/html&gt; &nbsp; &nbsp; 
 
2nd record &nbsp;… 
&lt;html&gt;&lt;p class=&quot;MsoNormal&quot;&gt;Good afternoon , on po number 57545 , part number 9362940 , 
p/s 449014 , we received 10 parts that are made incorrectly , please supply an 
rma number to return these incorrect parts also I believe we should be holding 
off on the remaining 115 on back order until vehicle improvements products 
updates it’s product , please advise , thank you&amp;nbsp;&lt;o:p&gt;&lt;/o:p&gt;&lt;/p&gt;&lt;/html&gt; 
 
Desired Output: 
 
1 record: &nbsp; 
hard horn buttons 
 
2 record: 
Good afternoon , on po number 57545 , part number 9362940 , 
p/s 449014 , we received 10 parts that are made incorrectly , please supply an 
rma number to return these incorrect parts also I believe we should be holding 
off on the remaining 115 on back order until vehicle improvements products 
updates it’s product , please advise , thank you 
 
Thanks in advance.
</div>
</div>

Hi All, 

While writing a report, I’m running into a road block when trying to extract data from a LONG datatype column that is stored with HTML tags. I tried REGEXP_REPLACE but it does not accept LONG datatype column. 

Here is an example of corrupted data:

1 record …. 
<html>hard horn buttons</html> 

2nd record …
<html>Good afternoon , on po number 57545 , part number 9362940 ,
p/s 449014 , we received 10 parts that are made incorrectly , please supply an
rma number to return these incorrect parts also I believe we should be holding
off on the remaining 115 on back order until vehicle improvements products
updates it’s product , please advise , thank you&nbsp;<o:p></o:p></html>

Desired Output: 

1 record: 
hard horn buttons 

2 record: 
Good afternoon , on po number 57545 , part number 9362940 ,
p/s 449014 , we received 10 parts that are made incorrectly , please supply an
rma number to return these incorrect parts also I believe we should be holding
off on the remaining 115 on back order until vehicle improvements products
updates it’s product , please advise , thank you 

Thanks in advance.

Extracting data from LONG datatype column that contains HTML tags.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.