Can you please suggest an efficient way to read the paramater values from each columns from DATABASE_A.TABLE_A and pass in the following commands in LOOP till all values in the list are processed....

INSERT INTO tgt_scma_1.tgt_tbl_1 SELECT * FROM src_scma_1.src_tbl_1;INSERT INTO tgt_scma_2.tgt_tbl_2 SELECT * FROM src_scma_2.src_tbl_2;INSERT INTO tgt_scma_3.tgt_tbl_3 SELECT * FROM src_scma_3.src_tbl_3;INSERT INTO tgt_scma_4.tgt_tbl_4 SELECT * FROM src_scma_4.src_tbl_4;