The problem I am trying to solve is relatively simple so I hope there is a decent solution in Oracle 10g. The problem is that I have several tables with field definitions which have a check constraint to restrict values to "Yes" or "No". It seems really wasteful that this same check constraint is repeated in other table definitions with similar fields. So I was looking to define my own data type with this general check constraint which I can then use as needed in any table definition.
I hope that makes sense. I would really appreciate any thoughts and experiences you could share with me to help me reach a decent solution.