Re: Can Check Constraints be Reused for Multiple Columns?

"GeoPappas" <PappasG_at_gmail.com> wrote:
> I have a bunch of columns that are a CHAR(1) and should only contain
> "Y" (for Yes) and "N" (for No).
>
> Instead of creating a separate check constraint for each and every
> column, is there a way to set up one check constraint and reuse it for
> multiple columns?

Why? Do you think that Oracle has a finite bag of check constraints and that it might run out?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB