/* update branch */ select * from branch; update branch b set b.city = 'Dallas'; select * from branch;