Re: Automated rounding ???

TurkBear schrieb:
>
> Perhaps the older DB dump was when the column was defined as number(8,2)[ or
> some other value] - In other words with a precision parameter - without one, I
> believe Oracle assumes Integer and will round ( you can 'tell' it to Trunc, but
> rounding is the default)

As far as i remember it was defined as "Number", and surely the same type in both (as we imported the dump WITH the data).

If i try "Number", it seems to acceppt comma values. Is there some oracle setup deciding if "Number" is int or float?

-- 
                                              Andreas
Seeing Dune worms, i don't want to see the Dune BIRDS...