For loops in model clause
From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Wed, 25 Jun 2008 13:31:59 -0500
Message-ID: <d7e2170806251131n6f3530a6kc375c82afecfab95@mail.gmail.com>
Date: Wed, 25 Jun 2008 13:31:59 -0500
Message-ID: <d7e2170806251131n6f3530a6kc375c82afecfab95@mail.gmail.com>
Hi list,
I'm playing with the model clause but, I'm having some trouble with a rule using a for loop.
dt_elig is a date column in the source table. The error I get is : ORA-32626 Illegal bounds or increment in MODEL FOR loop. Any idea about what I'm doing wrong?
*
FOR* dt_elig *FROM* to_date('01-Dec-07','DD-Mon-YY')
* TO* to_date('01-Jun-08','DD-Mon-YY')
*INCREMENT* numtoyminterval(1,'MONTH')
-- Regards GBA -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 25 2008 - 13:31:59 CDT