SQL> DESC AREAS;
Name Null? Type
----------------------------------------- -------- --------------
AREA NUMBER(3,3)
A NUMBER(2)
B NUMBER(2)


DECLARE
A NUMBER(2):=1;
B NUMBER(2):=2;
AREA NUMBER(3);
BEGIN
WHILE(A<5)
LOOP
AREA:=A+B;
INSERT INTO AREAS VALUES(AREA,A,B);
A:=A+1;
B:=B+1;
END LOOP;
END;
/


DECLARE
*
ERROR at line 1:
ORA-01438: value larger than specified precision allows for this column
ORA-06512: at line 9



WHARE AM I DOING WRONG?

PLEASE HELP ME

At a guess I would say that AREA NUMBER(3,3) is a number of three digits all three being to the right of the decimal point; thus the largest value you can consider would be 0.999