Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can Check Constraints be Reused for Multiple Columns?
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