today:
73
yesterday:
170
Total:
999,379

Column Data 일괄 추가

admin 2023.11.24 20:41 Views : 112

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
126 ACTION admin 2019.01.11 6454
125 Fundamentals of PL/SQL admin 2016.05.10 2031
124 QR Code plugin admin 2017.11.30 1585
123 QR Code plugin Process admin 2017.11.30 962
122 How to Update Oracle XE Version admin 2018.02.23 929
121 GP PRINT admin 2018.05.31 917
120 INSTR admin 2016.05.19 785
119 SELECT last_name FROM admin 2018.12.12 742
118 TREE admin 2016.05.18 722
117 IMP admin 2018.10.08 717
116 JK admin 2019.02.05 700
115 CREATE TABLE admin 2018.09.25 471
114 APEX Password Change admin 2016.08.26 452
113 JavaScript for Member List admin 2016.08.17 427
112 Membership Management admin 2016.06.09 425
111 QRCODE admin 2020.05.25 405
110 control break admin 2016.06.25 388
109 SQL admin 2016.07.15 387
108 DATE Compare admin 2018.05.22 365
107 APEX Web Services Proxy Settings admin 2016.06.07 351
Write Tag