Home

Friday, December 14, 2018

Inserting data into a table

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 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!!!

Latest Posts

Number of failed login attempts exceeds threshold value

Number of failed login attempts exceeds threshold value alert message comes from OEM. How to check what and which user is causing this? how ...

Popular Posts