Re: Help with complex SQL
Date: 5 Sep 2002 01:18:14 -0700
Message-ID: <f223e72a.0209050018.5b41aaa3_at_posting.google.com>
naeem.saleem_at_mandg.co.uk (Naeem) wrote in message news:<f223e72a.0209040321.67707d05_at_posting.google.com>...
> Hi all,
>
>
> Have the following two column in a table:-
>
> Maturity_date Schedule
> 01-DEC-2002 {01-JAN-2002 10,01-FEB-2002 20,01-JAN-2003 30}
>
> A date List of Dates and amounts with comma seperator.
>
> If any of the dates in the Schedule column are greater then the
> Maturity_date then I want to ignore them ... i.e. 01-JAN-2003 30 in
> the above example.......
>
> What is the easiest way of achieving this in SQL?
>
> Many thanks in advance.
Gents,
Many thanks for your replies......I just wanted to say (FYI) that
Maturity_Date and Schedule columns are part of a pretty large table
which has been part of an application for quite some time (SQLLOADER
---> Table --> PLSQL --> other tables)...but I will spare you the
Why/How/When/Where.....
A requirement has come to light which could involve what I explained in my original question and I just wanted to know if there was any "easy way" of achieving this (especially as 8i these days offers powerful features such as Analytical functions etc etc) before I go down the Design change avenue. Hence, wondered if someone out there ever had to do something similar..... Received on Thu Sep 05 2002 - 10:18:14 CEST