title: Oracle SYSDATE format Change
body: <p>I am trying to change a format of Oracle SYSDATE so that it uses a specific format when running a PL/SQL procedure. This format is really unnecessary but I am update an old table and need to maintain this format due to some integrations. My problem is I am not able to replicate the format.
  The format needed is: <code>15/MAR/17 09:31:08.000000000</code></p>
  
  <p>Currently the below is the closest I can get, I am not sure how to change <code>MM</code> to display MAR instead of 03.</p>
  
  <pre><code>SELECT TO_CHAR
      (SYSDATE, 'DD/MM/YY HH24:MI:SS.SSSSSSSSS')
  FROM DUAL;
  </code></pre>
  
  <p>Thanks a mill in advance</p>