Inserting a data through Dblinks:
Insert into ADMIN.T71 (C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8)
select C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8
from ARADMIN.T71@xyz.WORLD
SELECT * FROM ARADMIN.T71 WHERE DATE_SUB(NOW(), INTERVAL 1 HOUR) < UPDATE_TIME
Insert into ADMIN.T71 (C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8)
select C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8
from ARADMIN.T71@xyz.WORLD
SELECT * FROM ARADMIN.T71 WHERE DATE_SUB(NOW(), INTERVAL 1 HOUR) < UPDATE_TIME
INSERT INTO target_table (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM source_table;
INSERT INTO target_table (col1, col2, col3)
SELECT col1, col2, col3
FROM source_table;
Enjoy the work and do like me if you like this article!!!