Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Oracle Number length to SQL Numeric length

Author  Topic 

Starting Member

29 Posts

Posted - 2015-04-07 : 22:57:22
Hi, We are in the process of bringing our data over from Oracle to SQL so now some of the conversions are coming out differently. I need to make them the same in SQL as they were intended in Oracle. One such conversion I have is

Datatype Length Precision Scale
number 22

Datatype Length Precision Scale
numeric 17 38 0

I understand how it got 38 and 0 but I don't understand how it got the length of 17. Also, how would I change it (on the SQL side) to match that of Oracle? If anyone could point me in the right direction. Thanks!


22859 Posts

Posted - 2015-04-08 : 04:02:01
I'm guessing that your column datatype, in MS SQL, is FLOAT and perhaps you need to use DECIMAL instead? (or NUMERIC which is a synonym for DECIMAL - not sure which flavour Oracle uses )
Go to Top of Page

- Advertisement -