Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Different result from Excel

user540585Nov 2 2006 — edited Nov 2 2006

Hi all,

I hv done some thing with Excel for example

=(42-40)/1.5 and result is 1.333333333

When I am doing same with Oralce in "select statement", it is giving some different result, which is given below.

select Round((42-40)/1.5,9) from dual
the result is 1.003769326

Can any one help in this regards
thx

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2006

Added on Nov 2 2006

#general-database-discussions

4 comments

343 views