The SQL standard for DML UPDATE statements can be complex and convoluted and there are best practices ...
www.dba-oracle.com