SELECT CONCAT ('Oracle ','Internet Academy') AS "The Best Class" FROM Dual;
Use a merge statement to add to the manager_copy_d_cds table, the CDs from the original table. If there is a match, update title and the year. If not, insert the data from the original table.
MERGE INTO manager_copy_d_cds m USING d_cds d
ON (m cd_number=d cd_number)
WHEN MATCHED THEN UPDATE
SET
M title = d title,
M year = d year
WHEN NOT MATCHED THEN INSERT
VALUES(d title, d producer, d year, d cd_number);