Please help with INSERT question.

From: <agibbons_at_erols.com>
Date: Tue, 22 Sep 1998 17:16:00 -0400
Message-ID: <6u93vu$t4l$1_at_winter.news.erols.com>

[Quoted] [Quoted] Please can anyone help...why does the following insert data with only 2 decimal places?

I have a table with a column specified as:

col_1 NUMBER(16,8)

When I use:

INSERT INTO MY_TABLE (col_1) VALUES ('64.9695');

...the result is that only 64.97 is inserted into the database.

Any suggestions on how to get the complete 64.9695 into the field would be much appreciated.

Yours,

Elliot G. Received on Tue Sep 22 1998 - 23:16:00 CEST