oracle - Combining two tables using MERGE -
i trying combine 2 tables vertically
table
id salary 50 b 100
table b
id salary c 50 d 200
i trying table looks like
id salary 50 b 100 c 50 d 200
i using this:
merge table_a using ( select id, salary table b ) b on (a.id = b.id);
this not working.
your merge
syntax not correct. see below. read more merge here
merge table_a using (select id, salary table b) b on a.id = b.id when not matched insert (id,salary) values (b.id,b.salary);
Comments
Post a Comment