Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can Check Constraints be Reused for Multiple Columns?

Can Check Constraints be Reused for Multiple Columns?

From: GeoPappas <PappasG_at_gmail.com>
Date: 8 Aug 2005 11:25:27 -0700
Message-ID: <1123525527.687653.327550@f14g2000cwb.googlegroups.com>


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?

Or is there a better way of doing this? Received on Mon Aug 08 2005 - 13:25:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US