Member Avatar for muthu raj

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?

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.