looking for data type boolean


just start working with Toad Data Modeler (use the actual freeware version).

Actually problem is: How to set the data type BOOLEAN in attribute definition?

Do not find BYTE?

Is is a problem of the freeware Version? My used database type Oracle 11G should known data types like BOOLEAN

thanks for your support

best regards


Hello - in a Physical Model for Oracle you will not see BOOLEAN or BYTE because those are not Oracle supported datatypes.

Thanks for your quick answer, will use integer or char(1)

Best regards


Use integer (binary integer on new releases) rather then char/varchar … consistent (char 1 BYTE and char 1 CHAR might vary!!!) and better performance in general.