Oracle sql merge

-- Oracle: Example for Insert or update in t1 from t2 values 
MERGE INTO table1 t1
USING table2 t2
ON (t1.CODE = t2.ID)
WHEN MATCHED THEN
    UPDATE SET t1.COL1 = t2.VALUE1
WHEN NOT MATCHED THEN
    INSERT (CODE, COL1)  VALUES (t2.ID, t2.VALUE1);

Similar codes

3 votes206 views3 answers
Order by postgres
SQL
0 vote191 views1 answer
Start and stop mysql
SQL
0 vote159 views2 answers
Delete the last item in a table sql
SQL
0 vote211 views1 answer
Insert or update sql firebird
SQL
0 vote194 views1 answer
Postgres jsonb array push new element
SQL
6 votes199 views2 answers
If not exists insert sql
SQL
0 vote172 views1 answer
Sql examples from your work
SQL
0 vote187 views1 answer
Pl sql search saurce code
SQL
7 votes196 views3 answers
Convert ansi sql
SQL
0 vote183 views1 answer
Trigger value from maltiple table to single table mysql
SQL