Re: Numeric data type (newbie question)

Raha wrote:
>
> 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?
>

Yes, this is OK.

I estimate you use SQL*Plus, don't you? In that case you should read the documentation of your release. Look for the sqlplus command "COLUMN" which allows you to format columns after fetch.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!