today:
6
yesterday:
299
Total:
1,016,704

SQL LOOP TABLE UPDATE

admin 2023.05.19 13:12 Views : 78

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
21 TREE admin 2016.05.18 740
20 INSTR admin 2016.05.19 811
19 NVL admin 2016.05.19 175
18 ROWNUM admin 2016.05.19 255
17 FOR LOOP admin 2016.05.20 293
16 SUBSTR admin 2016.05.26 287
15 SQL admin 2016.07.15 415
14 How to Update Oracle XE admin 2018.04.25 161
13 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 147
12 DATE Compare admin 2018.05.22 384
11 How to convert DATE to NUMBER admin 2018.05.27 217
10 GP PRINT admin 2018.05.31 933
9 TABLE PRINT admin 2018.06.18 210
8 MISSIONARY_SUB admin 2018.06.25 222
7 VERY IMPORTANT admin 2018.06.26 250
6 CREATE TABLE admin 2018.09.25 491
5 SELECT last_name FROM admin 2018.12.12 768
4 ACTION admin 2019.01.11 6479
3 STARTUP admin 2022.09.01 107
» LOOP TABLE UPDATE admin 2023.05.19 78