today:
282
yesterday:
754
Total:
1,822,704

Technology

LOOP- PL/SQL

admin 2019.12.02 08:51 Views : 211

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;