---------------------- ASP.Net+Android+IO开发S、.Net培训、期待与您交流! -----------------------
首先执行以下语句可以查询1小时内删除的数据:
SELECT item_cost FROM cst_item_costs AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' hour) WHERE organization_id = 1 AND yyyymm = 200712 AND item_number = '6384BLCCSL';
UPDATE cst_item_costs SET item_cost = (SELECT item_cost FROM cst_item_costs AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' hour) WHERE organization_id = 1 AND yyyymm = 200712 AND item_number = '6384BLCCSL) WHERE organization_id = 1 AND yyyymm = 200712 AND item_number = '6384BLCCSL';
详细请查看:http://edu.csdn.net