Re: Numeric data type (newbie question)

From: Marc <langkamp_at_mailcity.com>
Date: Thu, 4 Oct 2001 10:19:21 +0200
Message-ID: <3bbc1b6c$1@gaspra.oss.akzonobel.nl>

Use the format command:
Column Column_Name Format <format_type>

eg column col1 format '999,999.99'

Hth

Marc

"Raha" <rahamaz_at_yahoo.com> wrote in message news:3bbbcd8c.0_at_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 Thu Oct 04 2001 - 03:19:21 CDT