Wrong result at select query
Posted: 21.04.2010, 07:42
Hello,
I have this problem. i use oracle 10g db and there i have table with field of NUMBER datatype. There i have value (number) with decimal point etc. (0.45).
i using zeos 6.6.6 .
so and when i open select query that result is 4 (original in db is 4.58).
when i open this query in sql developer that all is ok.
where is a problem please??
i am sorry for my English.
I have this problem. i use oracle 10g db and there i have table with field of NUMBER datatype. There i have value (number) with decimal point etc. (0.45).
i using zeos 6.6.6 .
so and when i open select query that result is 4 (original in db is 4.58).
when i open this query in sql developer that all is ok.
where is a problem please??
i am sorry for my English.