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 vote132 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote147 views1 answer
Sql roll up rows into columns
SQL
0 vote159 views1 answer
Pl sql round
SQL
0 vote166 views2 answers
What is rownum in oracle
SQL
0 vote138 views1 answer
Mssql current date
SQL
0 vote148 views1 answer
Restore backup mysql .gz
SQL
0 vote147 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote146 views1 answer
Oracle dynamic select into
SQL
0 vote150 views1 answer
GROUP BY postgres
SQL
1 vote155 views1 answer
Get create table query existing table mysql
SQL