Multiple choice technology databases

A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error during insertion

  1. 5392845.324

  2. 871039453.1

  3. 97234512.123

  4. 1234567.12
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A column defined as NUMBER(10,2) can hold up to 10 significant digits, with 2 of those to the right of the decimal point (leaving 8 digits for the integer part). '871039453.1' has 9 integer digits, causing an overflow error.

Keep practicing — related questions