How to populate a column in a table based on other columns?

Question

Oracle

Hello, can you tell me how you can fill the column of one (t1) table from the table (t2) in this way
: the rows of the name column depend on the rows of the id column.
In words, just in practice, I still can’t figure out how to decide, I’ve been working with Oracle recently. Of course, I know about update, and therefore we omit this method, is there another way? The id columns are of course unique, while the name columns are repeated.

Answer 1

MERGE Skip
the 'WHEN NOT MATCHED THEN...' section.