title: Oracle Pl/SQL: Loop through XMLTYPE nodes
body: <p>I have a XMLTYPE with the following content:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
      &lt;users&gt;
          &lt;user&gt;
              &lt;name&gt;user1&lt;/name&gt;
          &lt;/user&gt;
          &lt;user&gt;
              &lt;name&gt;user2&lt;/name&gt;
          &lt;/user&gt;
          &lt;user&gt;
              &lt;name&gt;user3&lt;/name&gt;
          &lt;/user&gt;
      &lt;/users&gt;
  </code></pre>
  
  <p>How can I loop in PL/SQL through all the elements "user"? Thanks</p>