Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle data type for a bit column

717086Aug 19 2009 — edited Aug 19 2009
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
This post has been answered by 630199 on Aug 19 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2009
Added on Aug 19 2009
#data, #sql
7 comments
23,724 views