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?