today:
97
yesterday:
802
Total:
1,589,929

Technology

LOOP- PL/SQL

admin 2019.12.02 07:51 Views : 193

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;