| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
