Updating two tables in oracle
Doing a 'join update' in Oracle can sometime cause a few headaches.By 'join update' I mean the situation where we have two tables and want to update some of the rows in the first table based on values that exist in the second table.
What is the SQL update syntax to update more than one column?
Some examples of DDL can be can be one condition, or multiple, dependent on what you need. be that you want to update just customers that are located in one area of the world.