title: Oracle 10g using regexp_replace on a CLOB
body: <p>I'd like to understand if it's possible via regular expression to extract a given attribute value in a stored Clob field.</p>
  
  <p>Say I have the following data.</p>
  
  <pre><code>AttrName1+AttrVal1;
  AttrName2+AttrVal2;
  AttrName3+;
  AttrName4+AttrVal4;
  AttrName5+;
  AttrName6+AttrVal7
  </code></pre>
  
  <p>Now in the select I'd like to check if AttrName2 has the value AttrVal2.</p>
  
  <p>Note not all attribute names do have a value necessarily. See AttrName3, AttrName 5</p>
  
  <p>Hope someone can enlighten me.</p>
  
  <p>I know it's achievable via dbms.function (instr, substr, etc) but maybe there's a simpler way.</p>