title: Search XML Column in SQL
body: <p>İ have an XML document to store against records in an Oracle Database.</p>
  
  <p>The table CourseXML will contain:</p>
  
  <pre><code>Record_Number  int
  XML_Type       int
  XMLDoc         clob
  ...etc
  </code></pre>
  
  <p>İ would like to make a search in XMLDoc column by XML tags. The XML document has an XML Schema like this:</p>
  
  <pre><code>&lt;root&gt;
    &lt;UnitID="2" Name="Jerry" SName="Potter"/&gt;
    &lt;UnitID="3" Name="Jim" SName="Carelyn"/&gt;
  &lt;/root&gt;
  </code></pre>
  
  <p>İ want to make search in UnitID="2" and i only want Jerry's xml row. How I have to make a select statement query to get that xml row?</p>