In the following example, the first UPDATE statement is executed when the condition is true, but the second UPDATE ...
docs.oracle.com