Oracle data types

An exact numeric data type that uses integer data.

bigint

from  -2^63  ( -9223372036854775808)   to  2^63-1  (9223372036854775807) Integer data for   (all numbers). The storage size is  8  bytes.

int

from  -2^31  ( -2,147,483,648)   to  2^31 - 1  (2,147,483,647) Integer data for   (all numbers). The storage size is  4  bytes. int  's  SQL-92  synonymous word is  integer.

smallint

Integer data from  -2^15  ( -32,768)   to  2^15 - 1  (32,767)  . The storage size is  2  bytes.

tinyint

Integer data from  0  to  255 . The storage size is  1  bytes. The

Comment
supports  bigint  data types where integer values are supported. However,,bigint  is used in some special cases, and  bigint can be used when the integer value exceeds the range supported by the  int  data type. The,int  data type in  SQL Server  is the primary integer data type. The

is,bigint  between  smallmoney  and  int  in the data type precedence table. &NBSP

The function returns  bigint only if the parameter expression is a  bigint  data type. sql server  does not automatically promote other integer data types (tinyint, smallint , and  int) to  bigint.