Numeric data type (newbie question)

From: Raha <rahamaz_at_yahoo.com>
Date: Thu, 4 Oct 2001 10:44:42 +0800
Message-ID: <3bbbcd8c.0@news.tm.net.my>

Hi,

I created a table:

create table tbl1 (col1 numeric(27,9));

Then, insert as below:

insert into tbl1 values (123.123456789);

insert into tbl1 values (1.123456789);

When I select from the table, it returned:

COL1

---

123.123456
1.12345679

How could this happen? Any setting in Oracle to control the way it display the value returned? I'm using the interactive SQL. Could anyone also suggest the best reference material?

Thanks in advance.

Regards,
Raha Received on Wed Oct 03 2001 - 21:44:42 CDT