title: Remove simple HTML-Tags from String in Oracle via RegExp, Explanation needed
body: <p>I do not understand, why my columns reg1 and reg2 remove "bbb" from my string, and only reg3 works as expected. </p>
  
  <pre><code>WITH t AS (SELECT 'aaa &lt;b&gt;bbb&lt;/b&gt; ccc' AS teststring FROM dual)
  
  SELECT
    teststring,
    regexp_replace(teststring, '&lt;.+&gt;') AS reg1,
    regexp_replace(teststring, '&lt;.*&gt;') AS reg2,
    regexp_replace(teststring, '&lt;.*?&gt;') AS reg3
  FROM t
  
  
  TESTSTRING             REG1        REG2          REG3
  aaa &lt;b&gt;bbb&lt;/b&gt; ccc     aaa ccc     aaa ccc       aaa bbb ccc
  </code></pre>
  
  <p>Thanks a lot!</p>