title: Need to find next and previous working day in oracle
body: <p>My query is somewhat like this:</p>
  
  <pre><code>select 1 from dual where :p1_task_date in (sysdate,sysdate+1,sysdate-1) and :p1_task_id is not null
  </code></pre>
  
  <p>This works fine, but I wanted to get next/previous working days (next/previous week days) instead of sysdate+1 and sysdate-1. I  tried something like:</p>
  
  <pre><code>select next_day(sysdate, to_char(sysdate+1,'DAY')) from dual`
  </code></pre>
  
  <p>but cannot proceed with this :(</p>
  
  <p>Please Help!!!!</p>