Oracle Table Data Types

Oracle tables support the following data types:

• Real - an approximate numeric data type.

• Float - a data type where all platforms have values of the least specified minimum precision.

• CLOB - a built-in data type that stores a Character Large Object as a column value in a row of a database table.

For all others, use the data types Float, Double, or CLOB and build them using a data type of “Other”.

Note - The Oracle driver does not support the boolean and PL/SQL RECORD datatypes in the Function and Stored Procedure.