oracle update 更新错误，修复

// 查询10分钟之前的zp_id
SELECT zp_id FROM DEGREE_CONFERED_IMAGE_REPORT AS OF TIMESTAMP SYSDATE-10/(24*60) ;

// 恢复数据
UPDATE DEGREE_CONFERED_IMAGE_REPORT a
SET a.zp_id = (
SELECT
b.zp_id
FROM
(
DEGREE_CONFERED_IMAGE_REPORT AS OF TIMESTAMP SYSDATE - 10 / ( 24 * 60 )) b
WHERE

a.id = b.id
)