Re: Building a List of "Sunday's"

See the post "Anyone have a DAYS_BETWEEN function?" in comp.databases.oracle.misc
you could use that solution with mods to get what you want in a single query

cheers ali...
Carl DiPasquale wrote in message <36DC2AAA.8E1E8F39_at_visteon.com>...
>We're trying to construct a mechanism to populate a Forms 4.5 List of
>Values with a running list of Sunday dates (format: DD-MON-YYYY). The
>only supplied input variables are the date range (1st Sunday and Last
>Sunday).
>
>We recognize that we can't populate an LOV with a PL/SQL procedure
>because a non-static LOV can only be generated from a single query.
>
>Does anyone have any ideas on how we can do this?
>
>Specs: H/P Unix 10.2
> Oracle 7.2.3
>
>Thanks in advance!
>
>Carl
Received on Thu Mar 11 1999 - 10:49:54 CET