today:
221
yesterday:
219
Total:
1,004,137

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
46 DATE Compare admin 2018.05.22 366
45 How to convert DATE to NUMBER admin 2018.05.27 198
44 GP PRINT admin 2018.05.31 918
43 TABLE PRINT admin 2018.06.18 186
42 eeeeee admin 2018.06.21 224
41 MISSIONARY_SUB admin 2018.06.25 199
40 IF/ELSE ... CASE WHEN admin 2018.06.25 209
39 VERY IMPORTANT admin 2018.06.26 226
38 Change Admin PASSWORD admin 2018.07.31 232
37 CREATE TABLE admin 2018.09.25 471
36 IMP admin 2018.10.08 719
35 SELECT last_name FROM admin 2018.12.12 742
34 ACTION admin 2019.01.11 6456
33 JK admin 2019.02.05 702
32 QRCODE admin 2020.05.25 405
31 How to Install Oracle 11g on Windows 10 - 64 bit | Download / Install Oracle 11g Database file admin 2022.03.17 120
30 SQL DEVELOPER file admin 2022.03.17 106
29 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
28 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157
27 STARTUP admin 2022.09.01 84
Write Tag