SmallInts and Integers are not coming out in Oracle as I would think?
Lets say I have:
On MySQL, MSSQL, etc, the column types are what I would expect. In Oracle, SMALLINT is mapped to Number and INT is mapped to INT. Both Number and INT are the same as Number(38) in Oracle I think. This ends up making a SmallInt and a Int bigger than the BIGINT which is Number(19,0). Is there a generic way to specify a SmallInt when creating columns that will come out to a SmallInt on each DB?