Question about Data Types

Toad Data Modeler
1

Hi I am new to Toad Modeler. I am using Toad Modoler 6.2, and can’t find a couple of data types such as Boolean, Text. Anyone can help me? Thanks in advance

2

Could you please specify database you use?

Thanks Daril

3

I think it’s oracle 10g.

4

TEXT is a Sql Server data type, not Oracle.

5

Boolean is an expression, not a data type.

A Boolean expression is a logical statement that is either TRUE or FALSE. Boolean expressions can compare data of any type as long as both parts of the expression have the same basic data type. You can test data to see if it is equal to, greater than, or less than other data.

6

How wrote Mark,

Oracle doesn’t has data type Boolean.

Regards