17,377
社区成员
发帖
与我相关
我的任务
分享
试试:
UPDATE TABLE1 A
SET NAME = (SELECT NAME
FROM TABLE1 B AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' HOUR)
WHERE SEX = '男'
AND A.ROWID = B.ROWID)
WHERE SEX = '男'
AND EXISTS (SELECT NULL
FROM TABLE1 B AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' HOUR)
WHERE SEX = '男'
AND A.ROWID = B.ROWID);