today:
613
yesterday:
719
Total:
1,770,397

Technology

LOOP- PL/SQL

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;