title: How to get NCLOB XML data from Oracle database
body: <p>We use a Java-based application to deploy XML files, which are written to an Oracle database. The XML blobs in the db are stored as NCLOB data types. How would I go about getting the NCLOB XML data from the database and back into XML format?  Would I need to use Java (I'm a complete Java noob, BTW), or could I use PowerShell here (my preference)?  And depending on the method, how would I do this?</p>
  
  <p>The reason I want to do this is mostly for pre/post deployment validation (compare the XML content before and after it's been deployed).</p>
  
  <p>Thanks in advance,
  Keith</p>