SQL Server data types equivalent to Oracle?
I was dealing a lot with importing exporting data in and our of MSSQL <-> Oracle and the simplest but also most accurate representation of a data type comparison was this one:http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/apa.htm
In your case you need to do the following:
- analyse the the field with the type
NUMBER
and try to find the scale/precision (might be server default values) - if you can't figure it out, analyze the values in the column and retrieve the maximum scale and precision from that
- Then create a
NUMERIC
field with that scale/precision in your MSSQL table
In General, the simplest way an oracle NUMBER
is represented by the NUMERIC
type. But in some cases the values are actually boleans, integers etc.