1 Reply Latest reply on Dec 7, 2009 7:09 PM by MMEGE-Oracle

    Migrate from MSSQL 'float' data column to Oracle NUMBER(n,m) or FLOAT(126)

      I am in process of migrating the existing MSSQL database to Oracle 10g R2 database. In the MSSQL database we have few tables with column of type float (MSSQL float data type) - what data type I should use for the correponding column in the oracle database table.

      I want to ensure that the data type which I use in Oracle will not result in data loss for the data stored in the column.

      Please help.