On 13 May 2013, at 4:57pm, Michael Black <mdblac...@yahoo.com> wrote:
> Oracle gives the right answer too for example(contrary to what somebody said > earlier). > > create table numtypes (A NUMERIC, B NUMERIC, C NUMERIC); > insert into numtypes values (1, 2, 25.23); > insert into numtypes values (1.0, 2, 27.17); > insert into numtypes values (1.1, 2, 22.92); > select A/B*C from numtypes; > > A/B*C > ---------- > 12.5 > 13.5 > 11.5 Please add to your INSERTs (1,2,21) and see whether Oracle is using integer arithmetic or not. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users