today:
236
yesterday:
219
Total:
1,004,152

Column Data 일괄 추가

admin 2023.11.24 20:41 Views : 140

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;
 
No. Subject Author Date Views
6 DATE -> DAY CONVERT SQL admin 2023.05.25 40
5 Monthly SUM admin 2023.05.22 40
4 ORACLE COLLECTION admin 2023.05.08 40
3 INNER JOIN admin 2023.05.19 39
2 TEST admin 2023.05.03 38
1 YEAR EXPRESSIONS admin 2023.05.25 35