Re: Please help with INSERT question.
From: Todd <chiwenlee41_at_hotmail.com>
Date: 23 Sep 1998 01:51:30 GMT
Message-ID: <01bde694$06b64a00$85a09384_at_sn0601.mail.accmail.com.tw>
Date: 23 Sep 1998 01:51:30 GMT
Message-ID: <01bde694$06b64a00$85a09384_at_sn0601.mail.accmail.com.tw>
Try this
INSERT INTO MY_TABLE (col_1) VALUES (64.9695);
> 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.
Received on Wed Sep 23 1998 - 03:51:30 CEST