today:
138
yesterday:
311
Total:
1,018,377

Column Data 일괄 추가

admin 2023.11.24 20:41 Views : 174

DECLARE
 
ROWNUM NUMBER;
BEGIN
ROWNUM := 175;
 
FOR i IN 1..ROWNUM
 
LOOP
UPDATE MEMBERS
 
SET
 MEMBER_ID = 3000 + 2*(SELECT ID FROM MEMBERS WHERE ID = i)
WHERE ID = i;
END LOOP;
END;
 
 
DECLARE
ROWNUM NUMBER;
BEGIN ROWNUM := 164;
FOR i IN 1..ROWNUM
LOOP
UPDATE SUNDAY_VISITORS
SET VISITOR_ID = 900000 + 2*(SELECT ID FROM SUNDAY_VISITORS WHERE ID = i)
WHERE ID = i;
END LOOP;
END;
 
I want to
List
No. Subject Author Date Views
6 Reversing Require HTTPS admin 2023.06.04 100
5 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 195
» Column Data 일괄 추가 admin 2023.11.24 174
3 영수증 2023 file admin 2024.01.04 297
2 Null Display Value admin 2024.01.10 160
1 LAST DAY SQL admin 2024.01.19 158
Write Tag