Hi all,

A small mapping question. Is the SQL Server data type 'real' equal to Oracledata type 'FLOAT'? I am wondering whether to convert real to float or Oracle number. When I use number, it seems to truncate the value after the decimal point.

Thanks,

Pankaj

Hi Pankaj,

There is no datatype FLOAT in Oracle ...you can implement the float using the NUMBER datatype in Oracle...the declaration is number(x,y)...where y is the precision and x is the total length inclusive of the precision...e.g. number(6,2) implies number of length 6 out of which 2 are reserved for the precision