For loops in model clause
- From: GBA-DBA <gba.oraclel@xxxxxxxxx>
- To: "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Jun 2008 13:31:59 -0500
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
Other related posts:
