title: PL/SQL Update that increments a variable
body: <p>I found the following approach on <a href="http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx" rel="nofollow">http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx</a> but have had no luck with PL/SQL.  Any thoughts?</p>
  
  <pre><code>update table    
  set table.column = var1 = var1 + 1    
  where table.column2 = "value';
  </code></pre>
  
  <p>It appears not to like the incrementing of var1 in the second half od the set line</p>