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: Ramola <j_ramola_at_yahoo.co.uk>
Date: 24 Sep 2001 21:49:21 -0700
Message-ID: <65c40e25.0109242049.3ce91636@posting.google.com>


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

Original text of this message

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