today:
584
yesterday:
635
Total:
1,556,343

Technology

LOOP & ROWNUM

admin 2020.10.04 18:20 Views : 53

DECLARE 

 ROWNUM NUMBER;

BEGIN

 FOR i IN 1..255

LOOP 

 UPDATE INVENTORY

 SET 

  BASE_QUANTITY = 1

WHERE i = ROWNUM;

END LOOP;

END;