today:
122
yesterday:
242
Total:
1,004,280

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;
 
I want to
List
No. Subject Author Date Views
106 TEST admin 2023.04.28 41
105 WHDR email address admin 2023.04.13 56
104 TEST admin 2023.03.27 100
103 GP 영수증 (3) -01/04/2023 admin 2023.01.04 53
102 GP - 영수증 (2) admin 2022.11.07 63
101 GP 영수증 본문 admin 2022.11.07 62
100 STARTUP admin 2022.09.01 84
99 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
98 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
97 SQL DEVELOPER file admin 2022.03.17 106
96 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 120
95 QRCODE admin 2020.05.25 405
94 JK admin 2019.02.05 702
93 ACTION admin 2019.01.11 6456
92 SELECT last_name FROM admin 2018.12.12 742
91 IMP admin 2018.10.08 719
90 CREATE TABLE admin 2018.09.25 471
89 Change Admin PASSWORD admin 2018.07.31 232
88 VERY IMPORTANT admin 2018.06.26 226
87 IF/ELSE ... CASE WHEN admin 2018.06.25 209
Write Tag