RSS Forums RSS

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

Please support our Oracle advertiser: Programming Forums
Reply
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?

  #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?
AddThis Social Bookmark Button
Reply With Quote  
Posts: 1,858
Reputation: debasisdas is on a distinguished road 
Solved Threads: 113
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Posting Virtuoso

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

  #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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Views: 689 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 10:03 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC