What is the precision value needed for Oracle for an Int32?

Question

I have a need to store a CRC signed Int32 value in Oracle. What precision should I use for that?

Answer 1

Since the max value of a signed int is 2,147,483,647 you'd use a precision of 10.

Answer 2

32 bits can store 2^32 or slightly more than 4,000,000,000 different numbers, so you'll need a NUMBER(10, 0).