Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I saw a bug in sqldeveloper 184.108.40.206 (maybe after ?, can't find this bug with google).
If you write an update query, and bind a floating number then, see theses few examples :
0.5 is binded to 0
1.5 is binded to 1.5
.5 is binded to 0.5
So, don't write the 0 before the coma if your number is between 0 and 1.
In a select query, there is no bug.
Didn't tryed the insert query.
Sorry for my english.
in 4.1, if i run
select :XYZ from dual
and supply 0.5, I get 0.5 back
if I run
select :XYZ - 3 from dual
and supply 0.5, I get -2.5 back
What are you doing?