In the database for a column of type clob i have value like this:
<span style="FONT-SIZE: 11pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial Narrow','sans-serif'; mso-bidi-font-family: 'Times New Roman'; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">AIRPORT IS OPEN 24 HRS <span style="mso-spacerun: yes"> </span></span>
<p></p>
I want to get the value as string in output .. I do not want all these html tags... i have found an article like the one mentioned below but still it is giving me clob value only
dbms_lob.substr( clob_column, for_how_many_bytes, from_which_byte );
for example:
select dbms_lob.substr( Column, 4000, 1 ) from Table;