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

Reply

Join Date: Apr 2008
Posts: 10
Reputation: muthu raj is an unknown quantity at this point 
Solved Threads: 0
muthu raj muthu raj is offline Offline
Newbie Poster

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

 
0
  #1
Oct 29th, 2008
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?
Reply With Quote Quick reply to this message  
Join Date: Feb 2007
Posts: 2,068
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 123
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Postaholic

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

 
0
  #2
Nov 1st, 2008
in oracle int is a sub type of number.so it has the same precision and scale as number.
NUMBER(38,-127)
Share your Knowledge.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC