将查询的数据插入到另一张表中 oracle

INSERT INTO TDATA.GD_ORDER_CYCLE_BAK
(C_SITE, C_XINGHAO_DESC, C_ORDER, C_ORDER_ITEM, C_ORDER_TYPE, C_CYCLE_TYPE, N_ZC_CYCLE, D_START_TIME, D_COMPLETE_TIME, N_CC, D_DATE)
(SELECT * FROM TDATA.GD_ORDER_CYCLE_TEST)

原文地址:https://www.cnblogs.com/zst-blogs/p/13626424.html