Oracle insert or update

-- 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

2 votes142 views2 answers
Change varchar length mysql
SQL
31 votes166 views3 answers
Sql count
SQL
4 votes168 views2 answers
Delete all table oracle
SQL
10 votes152 views3 answers
Insert into auto increment mysql
SQL
0 vote178 views1 answer
Mysql order by where condition sub query
SQL
0 vote153 views1 answer
Drop-toys-table
SQL
3 votes137 views1 answer
Oracle nextval
SQL
0 vote227 views1 answer
Import sql dump into postgresql database
SQL
3 votes147 views2 answers
Brew start mysql
SQL
0 vote145 views1 answer
What alter does in db
SQL