All Forums Database
thisisKumar 13 posts Joined 09/11
05 Apr 2012
Difference between 'Number' and 'Integer'

Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?

 

Thanks,

Kumar

 

Jim Chapman 449 posts Joined 09/04
06 Apr 2012

INTEGER is a 32-bit binary numeric type.  It has a fixed storage size of 4 bytes.

NUMBER is a new data type, introduced in Teradata 14.0, which is intended to emulate the Oracle number data type. It has an optional precision and scale of up to 38 decimal digits.  It can also represent exponential values. Its storage size varies from 0 to 18 bytes.

You must sign in to leave a comment.