today:
44
yesterday:
170
Total:
999,350

Column Data 일괄 추가

admin 2023.11.24 20:41 Views : 111

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 83
5 Using SQL*Plus to Unlock and Change Passwords admin 2023.06.04 130
» Column Data 일괄 추가 admin 2023.11.24 111
3 영수증 2023 file admin 2024.01.04 185
2 Null Display Value admin 2024.01.10 93
1 LAST DAY SQL admin 2024.01.19 95
Write Tag