title: Read xml tag value from oracle using sql developer
body: <pre><code>&lt;wbi:appData&gt;
      &lt;wbi:content wbi:name="1st_status"&gt;
          &lt;wbi:value xsi:type="xsd:string"&gt;Success&lt;/wbi:value&gt;
          &lt;/wbi:content&gt;
      &lt;/wbi:appData&gt;
  &lt;/wbi:event&gt;
  </code></pre>
  
  <p>I need to get the value "1st_status" which is in 2nd line and "Success" which is in 3rd line using SQL developer.</p>
  
  <p>this xml is in a table which has a column in the form of CLOB type.</p>