title: Oracle: How to create an element in a specific namespace with XMLElement()
body: <p>In Oracle, you can use the <a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions230.htm#i1129193" rel="nofollow noreferrer">XMLElement()</a> function to create an element, as in:</p>
  
  <pre><code>XMLElement('name', 'John')
  </code></pre>
  
  <p>But how to create an element in a specific namespace? For instance, how to create the following element:</p>
  
  <pre><code>&lt;my:name xmlns:my="http://www.example.com/my"&gt;John&lt;/my:name&gt;
  </code></pre>