today:
220
yesterday:
421
Total:
1,581,854

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;