title: Remove Single Quote from the column value in oracle sql
body: <p>Guys i want the following oracle sql query to print the following value. I want to remove single quote from the column value. Let me know how to do that</p>
  
  <pre><code>select MSGID from schemaname_interface_daily_20110427 ;
  </code></pre>
  
  <p><strong>Input:</strong></p>
  
  <pre><code>X'414d51204545415837313150202020204d54a9e423d31a16' 
  </code></pre>
  
  <p><strong>Output:</strong></p>
  
  <pre><code>X414d51204545415837313150202020204d54a9e423d31a16 
  </code></pre>