title: Regex to find multiple occurrence of string in column data for Oracle DB (11g)
body: <p>In one of the column, I have JSON data stored in text format. Sample data looks like:</p>
  
  <pre><code>{
      "dummy_time": "2016-04-27T18:44:55+00:00",
      "timeout_data": "2016-04-29T16:22:35+00:00,2016-04-30T16:22:35+00:00,2016-05-29T16:22:35+00:00",
      "time_id": "T101",
      "time_desc": "bla bla bla"
  }
  </code></pre>
  
  <p>I need to write SQL query to find out rows for whome this column has more than one date for key timeout_data. I am not that good with REGEX. I wrote simple query to find two occurences of dates in key timeout_data:</p>
  
  <pre><code>SELECT *
  FROM table1 f
  WHERE REGEXP_LIKE(f.data, '.+\"timeout_data\": \".+,.+\",\"time_id\".*')
  AND ROWNUM&lt;6;
  </code></pre>
  
  <p>And this query is running since ages. Table has around 35,000,000 rows.
  I am not sure how to find more than one occurrences of dates in key timeout_data. Please let me know if you require more information. </p>