Caculating "business days" in Oracle

My solution to calculating the number of business days using Oracle 8i is to create a table with holidays and run some kind of calculation like so:

select count(*)

    from ( select rownum rnum

             from all_objects
            where rownum <= to_date('&1') - to_date('&2')+1 )
   where to_char( to_date('&2')+rnum-1, 'DY' )
                not in ( 'SAT', 'SUN' )
     and not exists
        ( select null from table_of_holidays where no_work_day =
               trunc(to_date('&2')+rnum-1) )

If anyone knows of an easier solution that doesn't require a separate holiday table, let me know.

thanks,

Don Received on Thu May 19 2005 - 13:52:00 CDT