title: Boolean Field in Oracle
body: <p>Yesterday I wanted to add a boolean field to an Oracle table.  However, there isn't actually a boolean data type in Oracle.  Does anyone here know the best way to simulate a boolean?  Googling the subject discovered several approaches</p>
  
  <ol>
  <li><p>Use an integer and just don't bother assigning anything other than 0 or 1 to it.</p></li>
  <li><p>Use a char field with 'Y' or 'N' as the only two values.</p></li>
  <li><p>Use an enum with the CHECK constraint.</p></li>
  </ol>
  
  <p>Do experienced Oracle developers know which approach is preferred/canonical?</p>