一小段脚本,方便日后批量数据处理查询
BEGIN
FOR tr IN (SELECT ROWID AS rid FROM dw_pr_task_content_detail_test) LOOP
INSERT INTO lndwgl.dw_pr_task_content_detail@TO_DWTEST SELECT * FROM dw_pr_task_content_detail_test WHERE ROWID=tr.rid;
COMMIT;
END LOOP;
COMMIT;
END;