Re: Q: Constraints

From: Doug Meredith <dougm_at_nb.sympatico.ca>
Date: 1996/11/29
Message-ID: <329f2811.9171273@news.nb.sympatico.ca>#1/1

Roger Wernersson <roger.wernersson_at_adra.se> wrote:

>ALTER TABLE a ADD CONSTRAINT b CHECK (NVL (c, '-') IN ('Y', 'N'));
>
>or
>
>ALTER TABLE a MODIFY b NOT NULL;
>ALTER TABLE a ADD CONSTRAINT b CHECK (c IN ('Y', 'N'));

From a clarity point of view, I would pick the second option. Can't say what the effect on performance would be.

---

Doug Meredith
Manager, Consulting Services
Skyridge Systems Inc.
Moncton, NB, Canada

Tel: (506) 854-7997
Fax: (506) 855-9673
dougm_at_nb.sympatico.ca Received on Fri Nov 29 1996 - 00:00:00 CST