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

0 vote148 views1 answer
Delete insert record in sql server
SQL
1 vote148 views1 answer
How to get the date diff on once field in sql server
SQL
25 votes153 views6 answers
Modify column name in mysql
SQL
0 vote150 views1 answer
Drop specific row postgresql
SQL
0 vote155 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote152 views1 answer
Sql query to force the database to be drop
SQL
7 votes156 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote141 views1 answer
Mssql current date
SQL
0 vote530 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote155 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL