Script to transfer data from one table to another?

Question

Oracle

Hello everyone, there are 2 tablets on the oracle, they have the same name_id lines. It is necessary to transfer name_id from the first table to the second table in the name_id line. Do not tell me how the query is built, if possible, then an example would be very helpful. Thank you.

Answer 1

If you insert new rows then INSERT FROM SELECT
https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/...
If you update - https://asktom.oracle.com/pls/apex/asktom. search?t...