将查询的数据插入到另一张表中 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)
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)
