title: oracle sql: how to read XML and how to get value
body: <p>I'm new to oracle,i have XML column in table,in that column data is in XML format</p>
  
  <p>i.e,</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;charge textid="dacebab6-962e-3-b23d70eef85a" id="parse"&gt;&lt;properties/&gt;&lt;/charge&gt;
  </code></pre>
  
  <p>Now i want get only <strong>textid</strong>, so how to get textid thorough <strong>SQL</strong> query.</p>
  
  <p>i tried <strong>select XMLSequence(Extract(x,'/charge/textid/text()')) from emp_datails;</strong> but not working.</p>