Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NUMBER(1) vs NUMBER
number means allow any precision and scale so 1234.543 will work whereas
number(1) means only single digit numbers (-9 to 9) will work. There for
you can convert a number(1) to a number. (e.g. 1 will fit in a column where
1.245 is allowed.)
Jim
"Calydae" <calydae_at_ifrance.com> wrote in message
news:2001831-165147-488378_at_foorum.com...
>
> Hi all,
>
> We met a pb few days ago : when we insert with ASP code value 1 in a
NUMBER(1)
> column, everything was ok.
>
> Then : select * from table where column = 1 ==> nothing !!
> and select * from table where column = 0 ==> OK (other lines inserted
> before)
>
> BUT : select * from table where to_number(column) = 1 ==> OK
>
> I changed column format from NUMBER(1) to NUMBER and everything was Ok.
>
> So : NUMBER(1) != NUMBER ???
>
> Any idea ?
>
>
> Thanks
>
> ------
> User of http://www.foorum.com/. The best tools for usenet searching.
Received on Fri Aug 31 2001 - 11:19:57 CDT