BEGIN
\n\tFOR thr_grp_id IN 212..217 LOOP
\n\t\tFOR w IN 0..6 LOOP
\n\t\t\tFOR t IN 0..23 LOOP
\n\t\t\t insert into TABLENAME(THR_GRP_ID, ALM_TYPE_ID, WEEK_DAY, HOUR_ZONE, CRITICAL, MAJOR, MINOR, WARNING)
\n\t\t\t values(thr_grp_id, thr_grp_id, w, t, 20, 30, 40, 50);
\n\t\t\tEND LOOP;
\n\t\tEND LOOP;
\n\tEND LOOP;
\nEND;<\/code><\/p>\n===========================================================================================
\n#IF \uc870\uac74\ubb38<\/p>\n
1) IF \uc870\uac74 THEN \uba85\ub839\ubb38_1 -> IF \uc870\uac74 \ucc38 THEN \uc774\ud558 \uc2e4\ud589
\n END IF; -> IF \uc885\ub8cc
\n2) IF \uc870\uac74 THEN \uba85\ub839\ubb38_1
\n ELSE \uba85\ub839\ubb38_2
\n END IF;
\n3) IF \uc870\uac74_1 THEN \uba85\ub839\ubb38_1
\n ELSIF \uc870\uac74_2 THEN \uba85\ub839\ubb38_2
\n ELSIF \uc870\uac74_3 THEN \uba85\ub839\ubb38_3
\n …
\n ELSE \uba85\ub839\ubb38_n
\n END IF;<\/p>\n
SQL> set serveroutput on<\/p>\n
================================= (if\ubb38 \uc608\uc81c – 1)=============================
\nSQL>
\n declare
\n score01 int:=85;
\n grade01 varchar2(2);
\n BEGIN
\n IF score01>=90 THEN grade01:=’A’;
\n ELSIF score01>=80 THEN grade01:=’B’;
\n ELSIF score01>=70 THEN grade01:=’C’;
\n ELSIF score01>=60 THEN grade01:=’D’;
\n ELSE grade01:=’F’;
\n END IF;
\n dbms_output.put_line(‘\ub2f9\uc2e0\uc758 SCOR\ub294? ‘ || score01 || ‘\uc810\uc774\uace0,’ || ‘Grade\ub294? ‘ || grade01 || ‘\uc785\ub2c8\ub2e4.’);
\n end;
\n\/<\/p>\n
\/\/\ub2f9\uc2e0\uc758 SCORE\ub294? 85\uc810\uc774\uace0,Grade\ub294? B\uc785\ub2c8\ub2e4.<\/p>\n
================================= (if\ubb38 \uc608\uc81c – 2)=============================
\nSQL>
\ndeclare
\n i int := 10;
\nBEGIN
\nIF i !=20 THEN dbms_output.put_line(‘\ud604\uc7ac\uc758 \uac12\uc740? ‘|| i || ‘\uc774\ub2e4’);
\nEND IF;
\nEND;
\n\/
\n\/\/\ud604\uc7ac\uc758 \uac12\uc740? 10\uc774\ub2e4<\/p>\n
#FOR LOOP\ubb38
\n– \ubcc0\uc218\uac00 \ucd08\uae30 \uac12\ubd80\ud130 1\uc529 \uc99d\uac00\ud558\uc5ec \ucd5c\uc885 \uac12\uc774 \ub420 \ub54c\uae4c\uc9c0 \ubc18\ubcf5\ucc98\ub9ac
\n\ubb38\ubc95> FOR \ubcc0\uc218 IN \ucd08\uae30\uac12..\ucd5c\uc885\uac12 LOOP
\n \uba85\ub839\ubb381;
\n \uba85\ub839\ubb382;
\n ….
\n \uba85\ub839\ubb38N;
\n END LOOP;<\/p>\n
================================= (for\ubb38 \uc608\uc81c – 1)=============================
\n\uc608\uc81c 1\uc5d0\uc11c 10\uae4c\uc9c0 \ubc18\ubcf5\ud558\uc5ec TEST1 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\ub77c(FOR\ubb38 \uc0ac\uc6a9)<\/p>\n
\uba3c\uc800. SCOTT\uacc4\uc815\uc5d0\uc11c TEST1 \ud14c\uc774\ube14 \uc0dd\uc131
\n SQL> create table test1(bunho number(3), irum varchar2(10));<\/p>\n
SQL> BEGIN
\n FOR i IN 1..10 LOOP
\n insert into test1 values(i,SYSDATE);
\n END LOOP;
\n END;
\n \/
\n\uacb0\uacfc \ud655\uc778!>
\nSQL> select * from test1;
\n BUNHO IRUM
\n———- ———-
\n 1 07\/03\/19
\n 2 07\/03\/19
\n 3 07\/03\/19
\n 4 07\/03\/19
\n 5 07\/03\/19
\n 6 07\/03\/19
\n 7 07\/03\/19
\n 8 07\/03\/19
\n 9 07\/03\/19
\n 10 07\/03\/19
\n10 \uac1c\uc758 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
================================= (for\ubb38 \uc608\uc81c – 2)=============================
\nSQL>
\n declare i int := 0;
\n BEGIN
\n FOR i IN 0..50 LOOP
\n dbms_output.put_line(‘\ud604\uc7ac\uc758 i\uac12\uc740? ‘ || i || ‘\uc774\ub2e4’);
\n END LOOP;
\n END;
\n \/
\n\/\/\uacc4\uc815\uc774 \ubc14\uaf08\uc73c\ub2c8 set serveroutput on; \uaf2d \ud574\uc8fc\uae30!<\/p>\n
======================= \ud640\uc218\ub2e8\ub9cc \ucd9c\ub825(for\ubb38\uacfc if\ubb38 \ud63c\ud569)========================
\nSQL>
\n declare total number := 0;
\n BEGIN
\n FOR i IN 2..9 LOOP
\n IF MOD(i,2) 0 THEN –>2\ub85c \ub098\ub208 \ub098\uba38\uc9c0\uac00 0\uc774 \uc544\ub2c8\uba74 \ud640\uc218
\n dbms_output.put_line(i || ‘\ub2e8’);
\n dbms_output.put_line(‘==============’);
\n FOR j IN 2..9 LOOP
\n total := j * i;
\n dbms_output.put_line(i ||’ * ‘ || j || ‘ = ‘ || total);
\n END LOOP;
\n END IF;
\n END LOOP;
\n END;
\n \/<\/p>\n
\u203b \uacb0\uacfc\ubcf4\uae30
\nmore..<\/p>\n
========================== 1~50\uae4c\uc9c0 \ucd9c\ub825(while\ubb38)============================
\nSQL>
\n declare
\n i int := 0;
\n begin
\n while i
\ndeclare
\ntotal number := 0;
\nBEGIN
\nFOR i IN 2..9 LOOP
\n IF mod(i,2) 0 THEN
\n dbms_output.put_line(i || ‘\ub2e8’);
\n dbms_output.put_line(‘========’);
\n FOR j IN 3..7 LOOP
\n IF mod(j,2) 0 THEN
\n total := i * j;
\n dbms_output.put_line(i || ‘ * ‘ || j || ‘ = ‘ || total);
\n END IF;
\n END LOOP;
\n END IF;
\nEND LOOP;
\nEND;
\n \/<\/p>\n
\u203b \uacb0\uacfc\ubcf4\uae30
\nless..
\n3\ub2e8
\n========
\n3 * 3 = 9
\n3 * 5 = 15
\n3 * 7 = 21
\n5\ub2e8
\n========
\n5 * 3 = 15
\n5 * 5 = 25
\n5 * 7 = 35
\n7\ub2e8
\n========
\n7 * 3 = 21
\n7 * 5 = 35
\n7 * 7 = 49
\n9\ub2e8
\n========
\n9 * 3 = 27
\n9 * 5 = 45
\n9 * 7 = 63
\nless..<\/p>\n
=================== \uc9dd\uc218\ub2e8 \ucd9c\ub825\ud558\ub418, \uacf1\uc218\uac00 \ud640\uc218 \uc778\uac83===================
\nSQL>
\ndeclare
\n total number := 0;
\nBEGIN
\nFOR i IN 2..9 LOOP
\n IF mod(i,2) = 0 THEN
\n dbms_output.put_line(i || ‘\ub2e8’);
\n dbms_output.put_line(‘=========’);
\n FOR j IN 1..9 LOOP
\n IF mod(j,2) 0 THEN
\n total := i * j;
\n dbms_output.put_line(i || ‘ * ‘ || j || ‘ = ‘ || total);
\n END IF;
\n END LOOP;
\n END IF;
\nEND LOOP;
\nEND;
\n\/
\n\u203b \uacb0\uacfc\ubcf4\uae30
\nless..
\n2\ub2e8
\n=========
\n2 * 1 = 2
\n2 * 3 = 6
\n2 * 5 = 10
\n2 * 7 = 14
\n2 * 9 = 18
\n4\ub2e8
\n=========
\n4 * 1 = 4
\n4 * 3 = 12
\n4 * 5 = 20
\n4 * 7 = 28
\n4 * 9 = 36
\n6\ub2e8
\n=========
\n6 * 1 = 6
\n6 * 3 = 18
\n6 * 5 = 30
\n6 * 7 = 42
\n6 * 9 = 54
\n8\ub2e8
\n=========
\n8 * 1 = 8
\n8 * 3 = 24
\n8 * 5 = 40
\n8 * 7 = 56
\n8 * 9 = 72<\/p>\n
\ucd9c\ucc98 : http:\/\/annehouse.tistory.com\/84<\/p>\n","protected":false},"excerpt":{"rendered":"
PL\/SQL INSERT SAMPLE \uc0d8\ud50c\ub370\uc774\ud130 \ub123\uc744\ub824\uace0 \ub9cc\ub4e4\uc5b4\ubd24\ub2e4. \ubb50 \uc798\ucc98\ub9ac\ud558\uba74 THR_GRP_ID\ub3c4 \ubcc0\uc218\ub85c \ucc98\ub9ac\ud574\uc11c \ub123\uc744\uc218\uc788\uc744\uac70\uac19\uc740\ub370 \uae09\ud574\uc11c \uc774\ubd80\ubd84\uc740 \uc218\ub3d9\uc73c\ub85c\ud588\ub2e4. \ud1a0\ub4dc\uc5d0\uc11c \uc5d1\uc140 INSERT\ub3c4 \uc9c0\uc6d0\ud55c\ub2e4\uace0\ud55c\ub2e4. TOAD\uc5d0\uc11c excel\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 insert BEGIN FOR thr_grp_id IN 212..217 LOOP… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/478"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=478"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/478\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}