admin 2019.12.02 08:51 Views : 203
DECLARE
ROW_NUM NUMBER;
BEGIN
FOR i IN 1..265
LOOP
UPDATE HISTORY
SET
TOTAL_AMT = (select NVL(TO_NUMBER(TOTAL_AMOUNT),0) from history
WHERE i = ROW_NUM)
WHERE i = ROW_NUM;
END LOOP;
END;