ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MSSQL float data to Oracle NUMBER or FLOAT(126)

704087Dec 2 2009 — edited Feb 1 2010

Hi
I am in process of porting the existing MSSQL database to equivalent Oracle 10g2 database. I have several tables in MSSQL with column of type float (MSSQL float). Now I want to port these tables in Oracle 10g R2. Which type i should choose? NUMBER(m,n) or FLOAT(126)?

I want to ensure that data is not lost (precision/decimal places loss) when ported to Oracle.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2010

Added on Dec 2 2009

#odp-net

1 comment

2,687 views