title: Have regex ignore new lines and just match on a whole large string?
body: <p>I have this string here:</p>
  
  <pre><code>CREATE UNIQUE INDEX index555 ON
  SOME_TABLE
  (
      SOME_PK          ASC
  );
  </code></pre>
  
  <p>I want to match across the multiple lines and match the SQL statements (all of them, there will be many in 1 large string)... something like this, however I am only getting a match on <code>CREATE UNIQUE INDEX index555 ON</code></p>
  
  <pre><code>(CREATE\s.+;)
  </code></pre>
  
  <p>note: I am trying to accomplish this in java if it matters.</p>