today:
542
yesterday:
809
Total:
1,176,685

SQL LOOP TABLE UPDATE

admin 2023.05.19 14:12 Views : 263

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
129 127.0.0.1 issues admin 2024.09.09 175
128 GP 영수증 FOOTER admin 2024.06.30 321
127 GP 영수증 HEADER admin 2024.06.30 319
126 LAST DAY SQL admin 2024.01.19 289
125 Null Display Value admin 2024.01.10 283
124 영수증 2023 file admin 2024.01.04 427
123 Column Data 일괄 추가 admin 2023.11.24 248
122 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 256
121 Reversing Require HTTPS admin 2023.06.04 152
120 ipconfig admin 2023.06.03 128
119 127.0.0.1:8080/apex/ admin 2023.06.03 165
118 CHANGE TABLE NAME admin 2023.05.31 171
117 DATE -> DAY CONVERT SQL admin 2023.05.25 101
116 YEAR EXPRESSIONS admin 2023.05.25 95
115 GRAPH (BAR) SQL SAMPLE admin 2023.05.25 99
114 Monthly SUM admin 2023.05.22 135
113 INNER JOIN admin 2023.05.19 164
» LOOP TABLE UPDATE admin 2023.05.19 263
111 Global pages admin 2023.05.09 91
110 ORACLE COLLECTION admin 2023.05.08 99