This discussion is archived
1 Reply Latest reply: Dec 7, 2009 11:09 AM by MMEGE RSS

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

704087 Newbie
Currently Being Moderated
Hi
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points