looking for data type boolean

rbumann · October 23, 2013, 7:32am

Hi,

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

Raimar

kevinstern · October 23, 2013, 7:43am

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

rbumann · October 24, 2013, 2:08am

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

Best regards

Raimar

damir.vadas_250 · October 27, 2013, 12:41pm

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.