Hi,

I hav a sql command which retun the cost output.

I want to display cost upto procision 2 i.e. it should display 620.26.

When I am running in sql navigator it is roundin it to 620.3 which
changes the cost.

1 select segment1,round(list_price_per_unit,5) from mtl_system_items
where
2* list_price_per_unit=620.26

Is there any setting in the sql navigator which is making these value
change. I have to run this sql and then the output in excel file to
users.

Please help.

Regards,
Inder

Oracle LazyDBA home page