however here it is one:

INSERT INTO tableX (column1,column2 ) select column1,
column2 from TableY;

ARE you oracle guy? IF yes, it’s very misfortune that you do not know insert statement syntax, better join a training center or read oracle documentation.
Cheers
/MR