Skip to Main Content

Oracle Database Discussions

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!

create table w/Boolean column using check constraint

user12159859Jun 10 2013 — edited Jun 10 2013

Hi guys.

I am using Oracle 11.2 and have a request to create a simple table with one column as a Boolean datatype.

Since Oracle doesn't have a Boolean datatype, I created the column as a 'char' using a check constraint.

The input data is either a 'TRUE' or 'FALSE'.

One, when I went to load the data (using sqlldr), some records contain a null for this field and the record is rejected.

Is this normal behavior, and if so, how can i work around this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2013
Added on Jun 10 2013
9 comments
3,604 views