ROUND function

Hi

I have noticed some strange behaviour of Round function:

SQL> select round(2.34534543,2) from dual;

ROUND(2.34534543,2)

               2.35

SQL> select round(123456.2345345, 2) from dual;

ROUND(123456.2345345,2)

              123456.23

SQL>
SQL> select round(12345678.23423445, 2) from dual;

ROUND(12345678.23423445,2)

                  12345678

It seems that the function leaves no more than 8 digits??? Can anyone please comment?

(Oracle 7.3.3 for NT Server)

SY
Anton Received on Tue Jan 20 1998 - 00:00:00 CET