title: How below REGEXP_REPLACE works?
body: <p>I have query in my project and that is having <code>REGEXP_REPLACE</code>
  i tried to find how it works by searching but i found it like</p>
  
  <blockquote>
    <p>w+ Matches a word character (that is, an alphanumeric or underscore
    (_) character).</p>
  </blockquote>
  
  <p>but not able to find <code>'"\w+\":'</code> why these <code>""</code> are used and what is mean by <code>'{|}|"',''</code></p>
  
  <pre><code>UPDATE (SELECT data,data_value FROM  TEMP) t
  SET t.DATA_VALUE=REGEXP_REPLACE(REGEXP_REPLACE(t.data, '"\w+\":',''),'{|}|"','');
  </code></pre>
  
  <p>can you please tell me how it works?</p>