Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Implementation of boolean types.
Hi all,
I have seen many databases that tables with columns such as IsMale,IsFemale,
IsNull,Is...
All these were somekind of boolean type with yes/no or true/false or 1/0
values.In DBMSs that supports
boolean or bit data type it can be implemented naturaly but in Oracle that
does not have boolean or
bit,people usually use number(1) or char(1) for this purpose.
My question: Is this design OK in your opinion? I personally think that this
should be design using
a relationship with other tables such as HumanSex or...for scalability
reasons and so on (Not in fe/male situation! )
Any other ideas are highly appreciated.
-Thanks in advance
--
Message posted via http://www.dbmonster.com
Received on Wed Jul 13 2005 - 02:55:49 CDT