Home » SQL & PL/SQL » Client Tools » Rounding off in SQL Navigator
Rounding off in SQL Navigator [message #188479] Fri, 18 August 2006 13:19
Messages: 7
Registered: August 2005
Junior Member

I use SQL Navigator 4.5.1. The prolem is that it always rounds off the result in a query.

e.g if a value in table is o.o6 , it shows 0.1 and if it is o.o4 it shows 0.0. I have seached the help topics but couldn't find the solution.
One way is to use to_char(table_name) but it is not usefull when I want to use
select * from table_name

Can anyone help me sorting out this problem?

Previous Topic: Debugging Procedure with Toad
Next Topic: working with isql*plus
Goto Forum:

Current Time: Mon Oct 26 20:38:10 CDT 2020