title: Oracle REGEXP_SUBSTR from CLOB
body: <p>I'm trying to find a substring from a CLOB-field in my database.</p>
  <p>Consider the following string:</p>
  <blockquote>
  <p>someothertext 2. Grad Dekubitus (Druckgeschwür) mit
  Abschürfung/Blase/Hautverlust someothertext</p>
  </blockquote>
  <p>I only want to extract the <strong>&quot;2. Grad&quot;</strong> from the string, but my Regexp doesn't seem to work - I tested it on the string in some online regexp checkers, where it does actually work (<a href="http://regexr.com/5rbi2" rel="nofollow noreferrer">Fiddle</a>)</p>
  <p>This is my regular expression:</p>
  <pre><code>REGEXP_SUBSTR(DBMS_LOB.SUBSTR(cf.TEXT, 4000), '\b[0-9]\.\sGrad$') AS &quot;Grad&quot;
  </code></pre>
  <p>Currently, it returns NULL, but I'm not sure why.</p>
  <p>Any ideas on how to get this working?</p>