title: Next Business day from a date including US Holidays in Oracle SQL - no pl/sql code
body: <p>After reading and trying many sql codes, am still facing the issue.</p>
  
  <p>i need to calculate the 5th Businessday from a date. </p>
  
  <p>i need to remove 'saturday' 'sunday' and US Holidays</p>
  
  <p>i have a table which consists of US Holidays but coudn't able to join them properly in my sql </p>
  
  <pre><code>    BDATE       WEEKDAY_INDI
     ----------  --------------
  1   6/1/2014    WEEKEND
  2   6/2/2014    WEEKDAY
  3   6/3/2014    WEEKDAY
  4   6/4/2014    WEEKDAY
  5   6/5/2014    WEEKDAY
  6   6/6/2014    WEEKDAY
  7   6/7/2014    WEEKEND
  8   6/8/2014    WEEKEND
  </code></pre>
  
  <p>like wise i can get the weekdays and holidays in a table / separate tables</p>
  
  <p>I have a query </p>
  
  <pre><code>select * from ODM.team 
  </code></pre>
  
  <p>which gives </p>
  
  <pre><code>   NAME       DOB         DOB_MONTH   DOJ         UPDATED_DATE
    ---------- ----------- ----------- ----------- --------------
  1  Afnand     9/14/2000   September   2/20/2012   6/12/2014
  2  Angil      10/9/2000   October      5/5/2014   6/10/2014
  3  Asthwini   5/17/2000   May          4/6/2011   6/02/2014
  </code></pre>
  
  <p>I want to calculare the next Business day to <code>UPDATED_DATE</code></p>
  
  <p>For that i have treid to join the holidays table with the Team table, but it didn't worked</p>
  
  <p>Can you please suggest me how to get the next 5 th business day (excluding weekends, holidays).</p>