Oracle Tip: Choosing an efficient design for Boolean column values

June 10, 2004

[From Builder.com]

When designing a database table structure, it's important to choose an efficient strategy for storing a logical Boolean that you can use in many programming environments. (Although Oracle doesn't come with a Boolean datatype for database columns, it does have a Boolean datatype in PL/SQL.)

Any Boolean-defined column should also be properly constrained by checks to make sure that only valid values are entered at insert/update time.

The article continues at http://builder.com.com/5100-6388_14-5229553.html?tag=sc