title: oracle convert DD-MON-YY to DD/MM/YYYY
body: <p>I am trying to convert the format of a varchar2 column from '<strong>DD-MON-YY</strong>' to '<strong>DD/MM/YYYY</strong>'.</p>
  
  <p>In example: from '<strong>01-JAN-16</strong>' to '<strong>01/01/2016</strong>'</p>
  
  <p>In case you can ask or it may help:</p>
  
  <ul>
  <li>'MON' part is in English however my current NLS settings are in Turkish.</li>
  <li>All the years are after 2000.</li>
  </ul>
  
  <p>How can I do this?
  Thanks in advance..</p>