Update set with inner join oracle

UPDATE 
(SELECT table1.value as OLD, table2.CODE as NEW
 FROM table1
 INNER JOIN table2
 ON table1.value = table2.DESC
 WHERE table1.UPDATETYPE='blah'
) t
SET t.OLD = t.NEW

or

UPDATE table1 SET table1.value = (SELECT table2.CODE
                                  FROM table2 
                                  WHERE table1.value = table2.DESC)
WHERE table1.UPDATETYPE='blah'
AND EXISTS (SELECT table2.CODE
            FROM table2 
            WHERE table1.value = table2.DESC);

Source: stackoverflow.com

Similar codes

23 votes231 views3 answers
Sql where contains part of string
SQL
0 vote231 views1 answer
Alter table engine mysql
SQL
0 vote216 views1 answer
Connect to ssms with python
SQL
0 vote200 views1 answer
Postgresql import data from csv
SQL
1 vote239 views1 answer
Last 24 HOUR data in mysql
SQL
-1 vote213 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote247 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
2 votes215 views2 answers
Checking data type in sql server
SQL
1 vote206 views1 answer
Mysql find tables with column name
SQL
0 vote240 views1 answer
How to find symmetric pairs in sql
SQL