Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: need query

Re: need query

From: Himansu <m.himansu_at_sify.com>
Date: 24 Sep 2001 04:12:04 -0700
Message-ID: <33194ce2.0109240312.549d17f1@posting.google.com> 





Hi !


What if you enter all the Saturdays and Sundays in the HOLIDAY table
too along with the regular holidays ???


Else you may have to go for pl/sql, check each coming date if it is a
holiday(fetch from the holiday table as you do now)/saturday/sunday
and then make a work_day_counter increase once and then find the
module end day.



Regards


Himansu
Received on Mon Sep 24 2001 - 06:12:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US