I may unsubscribe at any time. You have exceeded the maximum character limit. If you need to update multiple columns simultaneously, use comma to separate each column after the SET keyword. This was last published in December Related Resources. Update data in a column in table A based on a common column in table B. How to do cross table update in Oracle Cross table update also known as correlated update, or multiple table update in Oracle uses non-standard SQL syntax format non ANSI standard to update rows in another table. Based on the fact that you have three columns including a date range in the SELECT, I'm going to assume that there are no completely duplicate employee date ranges.