Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Converting clob to string

user10873676Jan 27 2013 — edited Jan 29 2013
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&nbsp;<span style="mso-spacerun: yes">&nbsp;</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;
This post has been answered by odie_63 on Jan 28 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2013
Added on Jan 27 2013
4 comments
299 views