The UPDATE statement is used to update one or more columns in a table when certain conditions are met. Here, the updated columns cannot partition columns or bucket columns. The value used for updating should be an expression or constant rather than a subquery:
> UPDATE employee_trans > SET quite_date = current_date, quit_flag = 'Y'> WHERE emp_id = 104;No rows affected (39.745 seconds) > SELECT> quit_date, quit_flag > FROM employee_trans > WHERE emp_id = 104; -- Verify the update+-------------+-----------+| quit_date | quit_flag |+-------------+-----------+| 2018-04-20 | Y |+-------------+-----------+1 row selected (0.325 seconds)
