Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "GeoPappas" <PappasG@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Can Check Constraints be Reused for Multiple Columns?
Date: 8 Aug 2005 11:25:27 -0700
Organization: http://groups.google.com
Lines: 9
Message-ID: <1123525527.687653.327550@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 149.168.130.40
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123525533 26334 127.0.0.1 (8 Aug 2005 18:25:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 18:25:33 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=149.168.130.40;
   posting-account=dss88w0AAABryb2N1q1S0Tx_86Cyc4kY
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249118

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?