Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need query
hai...
i didn't enter all the saturdays and sundays..
into the holidays table...holidays table contains
government holidays such as JAN 1st,JAN 15th,JAN 26th...
and i want to check the saturday and sunday's dynamically
regards
ramola
m.himansu_at_sify.com (Himansu) wrote in message news:<33194ce2.0109240312.549d17f1_at_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 - 23:49:21 CDT