Hi. I want to join 2 tables. The second table exists in another database. I have created a database link. The 2 tables have the exact same definition.
I want to insert into table "CAUSE" from table "CAUSE". In other words, I want to insert missing rows from production to test. I cannot seem to get the correct syntax or proper method ? Please excuse me, but I have never coded before.
insert into CAUSE A as select from CAUSE@dblink B where A.num <> B.num;
Is the above correct ? Is there a better way ?