title: Oracle SQL convert HEX to char
body: <p>i am trying to convert a hexadecimal to character in Oracle ideally something like <a href="http://msdn.microsoft.com/en-us/library/ms187323.aspx" rel="nofollow">this</a> for Microsoft SQL Server</p>
  
  <pre><code>select xx('0A') from dual;
  </code></pre>
  
  <p>where <code>0A</code> is hexadecimal for newline in Unix.</p>