title: regex over multiple lines in Groovy
body: <p>I have a multiple line string like following:</p>
  
  <pre class="lang-sql prettyprint-override"><code>END IF;
  
  <b>EXECUTE IMMEDIATE ' CREATE INDEX #idx1
        ON somename ( row_id,
                             something)';</b>
     IF v_sys_error  0 THEN
        GOTO SQL_ERROR;
  
     END IF;
  
  </code></pre>
  
  <p>I wish to capture the part in bold (meaning everything from EXECUTE IMMEDIATE to next semicolon.</p>
  
  <p>I have the following regex but how can I change it to work with multiple lines?</p>
  
  <pre><code>(EXECUTE).*;
  </code></pre>