how to remove the html formatting in a lob fields
Hi,
how to remove the html tag formatting characters replacement ....
in a query for a field type lob
select dbms_lob.substr(A."COMMENT", DBMS_LOB.GETLENGTH (A."COMMENT"), 1)
from SD_REQUEST A
Result :
<p>Demande de 5 clés USB bluetooth </p>
<p>Demande de prêt de 6 clefs usb grande capacité.</p>
Extention mémoire.
<span style="font-size: small" class="Apple-style-span">EQ2009 - Plan de charges 2009 - Mise à jour Logiciel FileMaker</span>
<span style="font-size: small" class="Apple-style-span">EQ2009 - Plan de charges 2009 - File Maker (full)</span>
<font face="arial,helvetica,sans-serif" size="2" color="#000000">EQ2009 - Plan de charges 2009 - Maj Illustrator Mac</font>
how to remove the html tag formatting characters replacement ....
in a query for a field type lob
select dbms_lob.substr(A."COMMENT", DBMS_LOB.GETLENGTH (A."COMMENT"), 1)
from SD_REQUEST A
Result :
<p>Demande de 5 clés USB bluetooth </p>
<p>Demande de prêt de 6 clefs usb grande capacité.</p>
Extention mémoire.
<span style="font-size: small" class="Apple-style-span">EQ2009 - Plan de charges 2009 - Mise à jour Logiciel FileMaker</span>
<span style="font-size: small" class="Apple-style-span">EQ2009 - Plan de charges 2009 - File Maker (full)</span>
<font face="arial,helvetica,sans-serif" size="2" color="#000000">EQ2009 - Plan de charges 2009 - Maj Illustrator Mac</font>
0