title: Formatting a date in Oracle to show month and day
body: <p>I have the date as below</p>
  
  <pre><code>SELECT TO_CHAR(SYSDATE, 'DDD') FROM dual;
  </code></pre>
  
  <p>result for above query is : <code>117</code></p>
  
  <p>I need to convert this <strong>117</strong> to <strong>month and day</strong>. anyone knows how to perform this in PL SQL</p>
  
  <p><strong>the expected result is 04-27</strong></p>