943,649 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 874
  • Oracle RSS
Oct 29th, 2008
0

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

Expand Post »
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?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
muthu raj is offline Offline
10 posts
since Apr 2008
Nov 1st, 2008
0

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)
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: Diff b/w not exists and not in at oracle
Next Thread in Oracle Forum Timeline: Writing Unicode to Oracle





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC