title: How to convert week number to date range in Oracle?
body: <p>In Oracle we get week number from following query:</p>
  
  <pre><code>select to_char(TO_DATE(SYSDATE,'DD-MM-YY'),'IW') from dual
  </code></pre>
  
  <p>I want to get date range of given week number, <br>for example for week no:1 date range is 01-01-2017 to 08-01-2017.</p>
  
  <p>is there any way to get the date range for given week number?</p>