Re: Numeric data type (newbie question)

• post for FREE via your newsreader at post.newsfeeds.com ***

"Raha" <rahamaz_at_yahoo.com> wrote in message news:3bbbcc16.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
>
>

Hi Raha,

if you are using SQL*Plus you should set format of the query output. For your case type:
col col1 for 999999.999999999.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 90,000 Newsgroups - 16 Different Servers! =-----