DaniWeb IT Discussion Community - what is the max no of record for int Db type?

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Oracle (http://www.daniweb.com/forums/forum129.html)

- - what is the max no of record for int Db type? (http://www.daniweb.com/forums/thread154153.html)

muthu raj

Oct 29th, 2008 6:13 am

what is the max no of record for int Db type?

what is the maximum limit for int in data type.suppose in our table im specifying ID as int
type and assigning it as auto increment.After the int limit what will happen?what we will be
auto increment?

debasisdas

Nov 1st, 2008 4:09 am

Re: what is the max no of record for int Db type?

in oracle int is a sub type of number.so it has the same precision and scale as number.
NUMBER(38,-127)

All times are GMT -4. The time now is 1:09 am.