title: 0 rows updated while using update query in oracle
body: <p>When I am trying to update a column with character datatype using update statement. It says 0 rows update and does not throw any error. As the number of columns are much i tried using where clause using specific column out of it...where it updates the row.</p>
  
  <p>Issue is when all the columns are used to alter the value, it gives back 0 rows updated. I have to automate it in vba code/tool  so that it could update using all the rows. I identified the columns using which the value is not being updated but there is no error return. </p>
  
  <p>It only says:</p>
  
  <p><code>0 rows updated</code>.</p>
  
  <p>But what is wrong with that specific column(datatype...decimal).</p>
  
  <p>Please help. I have searched whole internet but no results.</p>