Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

Oracle Tip: Choosing an efficient design for Boolean column values

[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.