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

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?

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


Current Time: Sat Dec 03 18:07:39 CST 2016

Total time taken to generate the page: 0.09753 seconds