I have a table that features an XMLTYPE column containing CLOB data with XML and HTML content in it. I'm not quite sure how I can parse out the CDATA section and create a unique list of IDs contained within the javascript:openLink() string. Any ideas? I've tried searching the forums for how to read a CLOB and parse out each line, but didn't find the results I was looking for.
I've provided a sample of some of the content in this column:
<html><![CDATA[
<P>
<font face="Arial" SIZE="3">
<strong>
<span style="FONT-FAMILY: Arial">Recruiting</span>
</strong>
</font>
</P>
<P>
<A CLASS="divHyperLink" href="javascript:openLink(1010)">2008 Newsletters</A>
</P>
<P>
<A CLASS="divHyperLink" href="javascript:openLink(1009)">2007 Newsletters</A>
</P>
<P>
<A CLASS="divHyperLink" href="javascript:openLink(1008)">2006 Newsletters</A>
</P>
]]></html>
I basically need to output a list of IDs:
LinkID
1010
1009
1008