why does integer type change to number when alter a table?
627047Apr 27 2009 — edited Apr 27 2009I have converted a MSSQL database to Oracle 9i using the sql developer tools.
I got almost all the issues worked out, however, oracle changed all the integer datatypes from mssql to number(10,0) in oracle.
When my code does a comparison of a field value being returned it fails becuase it is comparing (1d) to 1.
When I try to change a column type or even add a new column in a table, I select integer but oracle changes it to number.
How can I change a data type from number to integer?