Unique constraint (%s.%s) violated - Error
<p>I am using Oracle database.</p>

<p>I am trying to update a record in a table using "Update ... Where ..." statement. </p>

<p>Even though I get only a one record when I execute a "Select * from ... where...." condition and using the same "Where" condition I am executing "Update" statement. I am getting below error:</p>

<pre><code>Error report -
SQL Error: ORA-00001: unique constraint (&lt;Unique Constraint Name&gt;) violated
00001. 00000 -  "unique constraint (%s.%s) violated"
*Cause:    An UPDATE or INSERT statement attempted to insert a duplicate key.
           For Trusted Oracle configured in DBMS MAC mode, you may see
           this message if a duplicate entry exists at a different level.
*Action:   Either remove the unique restriction or do not insert the key.
</code></pre>

<p>What I am not getting is when there is a single record which I get using "Where" condition and updating is affecting a single record, then what is the reason I am getting above error. </p>