today:
217
yesterday:
456
Total:
1,015,543

SQL LOOP TABLE UPDATE

admin 2023.05.19 13:12 Views : 66

BEGIN

 

     FOR x IN 1..(Select count(*) from HISTORY_BACKUP) LOOP

     

     UPDATE HISTORY_BACKUP

     SET PRODUCT_NUMBER = 

     (Select PRODUCT_NUMBER from PRODUCTS p

WHERE p.PRODUCT_ID = HISTORY_BACKUP.PRODUCTS);

     

 

  END LOOP;    

 

COMMIT;

END;

 
No. Subject Author Date Views
126 ACTION admin 2019.01.11 6468
125 Fundamentals of PL/SQL admin 2016.05.10 2049
124 QR Code plugin admin 2017.11.30 1595
123 QR Code plugin Process admin 2017.11.30 968
122 How to Update Oracle XE Version admin 2018.02.23 944
121 GP PRINT admin 2018.05.31 930
120 INSTR admin 2016.05.19 797
119 SELECT last_name FROM admin 2018.12.12 758
118 IMP admin 2018.10.08 737
117 TREE admin 2016.05.18 731
116 JK admin 2019.02.05 711
115 CREATE TABLE admin 2018.09.25 483
114 APEX Password Change admin 2016.08.26 467
113 JavaScript for Member List admin 2016.08.17 441
112 Membership Management admin 2016.06.09 441
111 QRCODE admin 2020.05.25 408
110 control break admin 2016.06.25 407
109 SQL admin 2016.07.15 404
108 DATE Compare admin 2018.05.22 378
107 APEX Web Services Proxy Settings admin 2016.06.07 372