title: How to extract group from regular expression in Oracle?
body: <p>I got this query and want to extract the value between the brackets.</p>
  
  <pre><code>select de_desc, regexp_substr(de_desc, '\[(.+)\]', 1)
  from DATABASE
  where col_name like '[%]';
  </code></pre>
  
  <p>It however gives me the value with the brackets such as "[TEST]". I just want "TEST". How do I modify the query to get it?</p>