Stepwise-Lab

ORA-01438: Value larger than specified precision allowed for this column

The number has more digits before the decimal point than NUMBER(p,s) allows (p - s digits). Extra digits after the decimal point are rounded instead.

On the exam

This error belongs to the topic Tables and constraints of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors