Re: View challenge
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sat, 12 Aug 2006 15:29:05 GMT
Message-ID: <5tmDg.39806$pu3.533163_at_ursa-nb00s0.nbnet.nb.ca>
Date: Sat, 12 Aug 2006 15:29:05 GMT
Message-ID: <5tmDg.39806$pu3.533163_at_ursa-nb00s0.nbnet.nb.ca>
frebe73_at_gmail.com wrote:
>>>Or he could use a closure to calculate the necessary series of integers
>>>or dates.
>>
>>Exactly right. But can it be done in MySQL's SQL?
>
> A solution in Oracle would be appreciated too.
You gave an example with an unspecified i earlier. Either Vadim or Mikito posted some examples recently for generating series of integers using Oracle's CONNECT BY clause.
If you google it, you should be able to find it quickly enough. Received on Sat Aug 12 2006 - 17:29:05 CEST