Re: Conditional Constraint?

From: J Alex <jalexanderssd_at_yahoo.com>
Date: Mon, 23 Dec 2002 12:44:59 GMT
Message-ID: <fzDN9.116714$Db4.3269056@twister.tampabay.rr.com>

"DA Morgan" <damorgan_at_exesolutions.com> wrote
> wing wrote:
>
> > Hi,
> >
> > I am new in Oracle and have a query on how to add conditional
> > constraint.
> >
> > Say, I have a simple table Demerit with three fields.
> >
> > Demerit(DEM_CODE, DEM_DES, POINTS)
> > where
> > DEM_CODE (N, 2)
> > DEM_DES (C, 30)
> > POINTS (N, 1)
> >
> > How to add the following constraint?
> >
> > All DEM_CODE should carry an integer POINT between 1 to 6 inclusive,
> > and DEM_CODE greater than 20 should carry no more than 3 POINT.
> >
> > Thanks in advance of any ideas and inputs.
> >
> > Wing
>
> What you are trying to do requires a trigger.

No, it doesn't. Check constraints work well for this sort of thing. Note Jonathon Lewis' post with the constraint. Received on Mon Dec 23 2002 - 06:44:59 CST