title: How to use REGEX_SUBSTR
body: <p>I need to extract a substring from a long string. I tried the following query but doesn't work , it returns me NULL,
  I want to extract the first value 12 between the <code>&lt;cc&gt;</code> and <code>&lt;/cc&gt;</code></p>
  
  <pre><code>select regexp_substr('&lt;CC&gt;3&lt;/CC&gt;&lt;CN&gt;ROSSI&lt;/CN&gt;&lt;NO&gt;MARIO&lt;/NO&gt;&lt;IN&gt;VIA DELLE MIMOSE 4&lt;/IN&gt;,'&lt;CN&gt;[^&lt;/CN&gt;]*') 
  "REGEXPR_SUBSTR"
  FROM DUAL;
  </code></pre>
  
  <p>I get as a result <code>&lt;CN&gt;ROSSI</code> but I want also to eliminate also the  <code>&lt;CN&gt;</code> , any suggestion?</p>