Oracle的这语句转换到达梦应该是什么啊下面是要转换的语句
FOR TEMP1 IN CUR3
LOOP
DBMS_OUTPUT.PUT_LINE(TEMP1.ENTITY_ID||‘,’||TEMP1.Scene_id);
SELECT UUID INTO v_uuid from DW_EVENTCENTER.SC_ENTITY_SC_RE WHERE ENTITY_ID=TEMP1.ENTITY_ID and SCENE_ID=TEMP1.Scene_id AND rownum=1;
UPDATE DW_EVENTCENTER.SC_ENTITY_SC_RE A SET A.ENTY_NAME=(SELECT B.ETPS_NAME FROM GS_ETPS_INFO@TOQZGX_QX_2018 B WHERE A.ENTITY_ID=B.ETPS_ID) WHERE UUID=v_uuid;
DELETE FROM DW_EVENTCENTER.SC_ENTITY_SC_RE A WHERE ENTITY_ID=TEMP1.ENTITY_ID and SCENE_ID=TEMP1.Scene_id AND UUID<>v_uuid;
COMMIT;
END LOOP;
COMMIT;