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

0 vote328 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote379 views1 answer
Alter database datafile maxsize 32g
SQL
3 votes347 views1 answer
Postgresql db owner change
SQL
7 votes345 views1 answer
Oracle reset sequence
SQL
1 vote326 views1 answer
Oracle create program if no exists
SQL
0 vote336 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote333 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote398 views1 answer
Sql alternative to max statement
SQL
0 vote384 views1 answer
Python dictionary to sql update
SQL
0 vote324 views1 answer
Change default schema sql server
SQL