7 Replies Latest reply on Aug 19, 2009 5:47 AM by 673860

    oracle data type for a bit column

    717086
      I want to add a new column to my table, but I cant seem to find a bit data type in oracle. the only data in the field will be either 1 or 0. whats the best data type to use?

      Also, is this the correct SQL to add a new colun "flag" to table tblLocations:

      ALTER TABLE tblLocations
      ALTER COLUMN flag bit

      Thanks
      Mark