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

8 votes205 views1 answer
Oracle tablespace datafile max size
SQL
0 vote191 views1 answer
Pip install mysqlclient error
SQL
0 vote197 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote195 views2 answers
Create-toys-table-with-toy_name-column
SQL
3 votes185 views3 answers
Remove all spaces from string sql
SQL
0 vote187 views1 answer
Sql file in postgres with pgadmin
SQL
2 votes149 views1 answer
Sql view column data type
SQL
32 votes196 views6 answers
Insert into values select
SQL
103 votes322 views1 answer
Like sql
SQL
0 vote171 views1 answer
Month mysql
SQL