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 votes152 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
26 votes151 views2 answers
Mysql workbench download
SQL
0 vote164 views1 answer
Uncheck constraints and delete from table
SQL
13 votes141 views4 answers
Mysql get last row
SQL
7 votes149 views2 answers
Oracle sql drop index
SQL
21 votes151 views4 answers
Oracle add column
SQL
9 votes157 views2 answers
Convert data type in sql
SQL
3 votes150 views4 answers
Truncate syntax in sql
SQL
32 votes173 views6 answers
Rename column mysql
SQL
5 votes138 views2 answers
Mysqldump password
SQL