Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Numeric data type (newbie question)

Numeric data type (newbie question)

From: Raha <rahamaz_at_yahoo.com>
Date: Thu, 4 Oct 2001 10:38:27 +0800
Message-ID: <3bbbcc16.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:38:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US