[SQL]Boolean Field in Oracle

参考:https://*.com/questions/30062/boolean-field-in-oracle

 

1. Use an integer and just don't bother assigning anything other than 0 or 1 to it.

2. Use a char field with 'Y' or 'N' as the only two values.

3. Use an enum with the CHECK constraint.