{"id":1242,"date":"2016-01-03T14:36:40","date_gmt":"2016-01-03T14:36:40","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1242"},"modified":"2016-01-03T14:36:40","modified_gmt":"2016-01-03T14:36:40","slug":"5-plsql-%ec%a0%9c%ec%96%b4%ea%b5%ac%ec%a1%b0-%ec%9e%91%ec%84%b1","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1242","title":{"rendered":"5. PL\/SQL \uc81c\uc5b4\uad6c\uc870 \uc791\uc131"},"content":{"rendered":"

5. PL\/SQL \uc81c\uc5b4\uad6c\uc870 \uc791\uc131 <\/P>
\n

 <\/P>
\n

A. IF Statement<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

IF condition THEN<\/SPAN><\/P>
\n

statements;<\/SPAN><\/P>
\n

[ELSIF condition THEN<\/SPAN><\/P>
\n

statements;]<\/SPAN><\/P>
\n

[ELSE<\/SPAN><\/P>
\n

statements;]<\/SPAN><\/P>
\n

END IF;<\/SPAN><\/P>
\n

ex)<\/P>
\n

1) \uac04\ub2e8\ud55c IF \ubb38<\/P>
\n

DECLARE<\/SPAN><\/P>
\n

v_myage<\/SPAN> number := 30;<\/SPAN><\/P>
\n

BEGIN<\/SPAN><\/P>
\n

IF <\/SPAN>v_myage<\/SPAN> < 11<\/SPAN><\/P>
\n

THEN<\/SPAN><\/P>
\n

DBMS_OUTPUT.PUT_LINE(\u2018 I am a child \u2018);<\/SPAN><\/P>
\n

END IF;<\/SPAN><\/P>
\n

END;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

2) if then else \ubb38<\/P>
\n

declare<\/SPAN><\/P>
\n

v_myage<\/SPAN> number := &<\/SPAN>myage<\/SPAN>;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

if <\/SPAN>v_myage<\/SPAN> < 20 then<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am young \u2018);<\/SPAN><\/P>
\n

elsif<\/SPAN> <\/SPAN>v_myage<\/SPAN> < 30 then<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am in my twenties \u2019);<\/SPAN><\/P>
\n

elsif<\/SPAN> <\/SPAN>v_myage<\/SPAN> < 40 then<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am in my thirties \u2019);<\/SPAN><\/P>
\n

else<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am always young \u2018);<\/SPAN><\/P>
\n

end if;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

B. IF \ubb38\uc758 NULL \uac12<\/P>
\n

declare<\/SPAN><\/P>
\n

v_myage<\/SPAN> number;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

if <\/SPAN>v_myage<\/SPAN> < 11 then<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am a child \u2018);<\/SPAN><\/P>
\n

else<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018 I am not a child \u2018);<\/SPAN><\/P>
\n

end if;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

– v_myage \ubcc0\uc218\uac00 \ucd08\uae30\ud654 \ub418\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc5d0 null \uac12\uc744 \ubc18\ud658\ud558\uc5ec else \ubb38\uc73c\ub85c \uc774\ub3d9<\/P>
\n

 <\/P>
\n

C. CASE \uc2dd<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

CASE selector<\/SPAN><\/P>
\n

WHEN expression1 THEN result1<\/SPAN><\/P>
\n

WHEN expression2 THEN result2<\/SPAN><\/P>
\n

\u2026.<\/SPAN><\/P>
\n

WHEN <\/SPAN>expressionN<\/SPAN> THEN <\/SPAN>resultN<\/SPAN><\/P>
\n

[ELSE resultN+1]<\/SPAN><\/P>
\n

END;<\/SPAN><\/P>
\n

 <\/P>
\n

ex) \ub450\uac00\uc9c0 \ubc29\uc2dd\uc758 \uc0ac\uc6a9\ubc95<\/P>
\n

1) v_grade \uac12\uc744 \ud45c\ud604\uc2dd\uc73c\ub85c \uc0ac\uc6a9<\/P>
\n

declare<\/SPAN><\/P>
\n

v_grade<\/SPAN> char(1) := upper(\u2018&grade\u2019);<\/SPAN><\/P>
\n

v_appraisal<\/SPAN> varchar2(20) ;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

v_appraisal<\/SPAN> := case <\/SPAN>v_grade<\/SPAN><\/P>
\n

when \u2018A\u2019 then \u2018Excellent\u2019<\/SPAN><\/P>
\n

when \u2018B\u2019 then \u2018Good\u2019<\/SPAN><\/P>
\n

when \u2018C\u2019 then \u2018Loser!!\u2019<\/SPAN><\/P>
\n

else \u2018No such grade\u2019<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN> (\u2018Grade: \u2018 || <\/SPAN>v_grade<\/SPAN> || \u2018 Appraisal \u2018 || <\/SPAN>v_appraisal<\/SPAN>);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

 <\/P>
\n

2) when \uc808\uc5d0 \ubd80\uc6b8 \uac12\uc744 \uc0dd\uc131\ud558\ub294 \ud45c\ud604\uc2dd\uc774 \ud3ec\ud568<\/P>
\n

declare<\/SPAN><\/P>
\n

v_grade<\/SPAN> char(1) := upper(\u2018&grade\u2019);<\/SPAN><\/P>
\n

v_appraisal<\/SPAN> varchar2(20);<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

v_apprasial<\/SPAN> := case<\/SPAN><\/P>
\n

when <\/SPAN>v_grade<\/SPAN> = \u2018A\u2019 then \u2018Excellent\u2019<\/SPAN><\/P>
\n

when <\/SPAN>v_grade<\/SPAN> in(\u2018B\u2019, \u2019C\u2019) then \u2018Good\u2019<\/SPAN><\/P>
\n

else \u2018No such grade\u2019<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN> (\u2018Grade: \u2018 || <\/SPAN>v_grade<\/SPAN> || \u2018Appraisal \u2018 || <\/SPAN>v_appraisal<\/SPAN>);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

 <\/P>
\n

D. CASE \uc2dd\uacfc CASE \ubb38<\/P>
\n

<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>CASE <\/SPAN>\uc2dd\uc740 \uc870\uac74\uc744 \ud3c9\uac00\ud558\uc5ec \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc18\uba74\uc5d0<\/SPAN><\/DIV>
\n

  <\/SPAN>CASE <\/SPAN><\/SPAN>\ubb38\uc740 \uc870\uac74\uc744 \ud3c9\uac00\ud558\uc5ec \uc791\uc5c5\uc744 \uc218\ud589<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>CASE <\/SPAN>\uc2dd\uc740 <\/SPAN>END; <\/SPAN>\ub85c \uc885\ub8cc<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>CASE <\/SPAN>\ubb38\uc740 <\/SPAN>END CASE; <\/SPAN>\ub85c \uc885\ub8cc<\/SPAN><\/DIV>
\n
<\/DIV>
\n

– CASE \ubb38 \uc608\uc81c<\/P>
\n

<\/P><\/p>\n

 <\/p>\n

E. NULL \ucc98\ub9ac<\/P><\/p>\n

 <\/p>\n

<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>NULL <\/SPAN>\uc744 \uc0ac\uc6a9\ud558\ub294 \ub2e8\uc21c \ube44\uad50\ub294 \ud56d\uc0c1 <\/SPAN>NULL <\/SPAN>\uc744 \ubc18\ud658<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub17c\ub9ac\uc5f0\uc0b0\uc790 <\/SPAN>NOT<\/SPAN>\uc744 <\/SPAN>NULL <\/SPAN>\uc5d0 \uc801\uc6a9\ud558\uba74 <\/SPAN>NULL <\/SPAN>\uc774 \ubc1c\uc0dd\ud55c\ub2e4<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc870\uac74 <\/SPAN>\uc81c\uc5b4\ubb38\uc5d0\uc11c<\/SPAN> \uc870\uac74\uc774 <\/SPAN>NULL <\/SPAN>\uc744 \ubc18\ud658\ud558\uba74 \uc5f0\uad00\ub41c \uba85\ub839\ubb38\uc774 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n

– \ub17c\ub9ac\ud14c\uc774\ube14<\/P>
\n

<\/P>
\n

 <\/P>
\n

F. \ubc18\ubcf5\uc81c\uc5b4 : LOOP \ubb38<\/P>
\n

1) Basic Loop<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

LOOP<\/SPAN><\/P>
\n

statement1;<\/SPAN><\/P>
\n

\u2026<\/SPAN><\/P>
\n

EXIT [WHEN condition];<\/SPAN><\/P>
\n

END LOOP;<\/SPAN><\/P>
\n

<\/DIV>
\n
<\/DIV>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

v_countryid<\/SPAN>  <\/SPAN><\/SPAN>locations.country_id%type<\/SPAN> := \u2018CA\u2019;<\/SPAN><\/P>
\n

v_loc_id<\/SPAN>  <\/SPAN><\/SPAN>locations.location_id%type<\/SPAN>;<\/SPAN><\/P>
\n

v_counter<\/SPAN>  <\/SPAN>number(2) := 1;<\/SPAN><\/SPAN><\/P>
\n

v_new_city<\/SPAN>  <\/SPAN><\/SPAN>locations.city%type<\/SPAN> := \u2018Montreal\u2019;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

select max(<\/SPAN>location_id<\/SPAN>) into <\/SPAN>v_loc_id<\/SPAN> from locations<\/SPAN><\/P>
\n

where <\/SPAN>country_id<\/SPAN> = <\/SPAN>v_countryid<\/SPAN>;<\/SPAN><\/P>
\n

loop<\/SPAN><\/P>
\n

insert into locations(<\/SPAN>location_id<\/SPAN>, city, <\/SPAN>country_id<\/SPAN>)<\/SPAN><\/P>
\n

values((<\/SPAN>v_loc_id<\/SPAN> + <\/SPAN>v_counter<\/SPAN>), <\/SPAN>v_new_city<\/SPAN>, <\/SPAN>v_countryid<\/SPAN>);<\/SPAN><\/P>
\n

v_counter<\/SPAN> := <\/SPAN>v_counter<\/SPAN> + 1;<\/SPAN><\/P>
\n

exit when <\/SPAN>v_counter<\/SPAN> > 3;<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

2) while Loop<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

WHILE condition loop<\/SPAN><\/P>
\n

statement1;<\/SPAN><\/P>
\n

statement2;<\/SPAN><\/P>
\n

\u2026<\/SPAN><\/P>
\n

END LOOP;<\/SPAN><\/P>
\n

<\/DIV>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

v_counterid<\/SPAN>  <\/SPAN><\/SPAN>locations.country_id%type<\/SPAN> := \u2018CA\u2019;<\/SPAN><\/P>
\n

v_loc_id<\/SPAN>  <\/SPAN><\/SPAN>locations.location_id%type<\/SPAN>;<\/SPAN><\/P>
\n

v_new_city<\/SPAN>  <\/SPAN><\/SPAN>locations.city%type<\/SPAN> := \u2018Montreal\u2019;<\/SPAN><\/P>
\n

v_counter<\/SPAN>  <\/SPAN>number := 1;<\/SPAN><\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

select max(<\/SPAN>location_id<\/SPAN>) into <\/SPAN>v_loc_id<\/SPAN> from locations<\/SPAN><\/P>
\n

where <\/SPAN>country_id<\/SPAN> = <\/SPAN>v_countryid<\/SPAN>;<\/SPAN><\/P>
\n

while <\/SPAN>v_counter<\/SPAN> <= 3 loop<\/SPAN><\/P>
\n

insert into locations(<\/SPAN>location_id<\/SPAN>, city, <\/SPAN>country_id<\/SPAN>)<\/SPAN><\/P>
\n

values((<\/SPAN>v_loc_id<\/SPAN> + <\/SPAN>v_counter<\/SPAN>), <\/SPAN>v_new_city<\/SPAN>, <\/SPAN>v_counteryid<\/SPAN>);<\/SPAN><\/P>
\n

v_counter<\/SPAN> := <\/SPAN>v_counter<\/SPAN> + 1;<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

3) FOR Loop<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\ubc18\ubcf5 \ud69f\uc218\uc5d0 \ub300\ud55c \ud14c\uc2a4\ud2b8\ub97c \ub2e8\ucd95\ud558\ub824\uba74 <\/SPAN>FOR loop <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uce74\uc6b4\ud130\ub294 \ubb35\uc2dc\uc801\uc73c\ub85c \uc120\uc5b8\ub418\ubbc0\ub85c \uc120\uc5b8\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

FOR counter IN [REVERSE]<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>lower_bound<\/SPAN>..<\/SPAN>upper_bound<\/SPAN> LOOP<\/SPAN><\/P>
\n

  <\/SPAN>statement1;<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>statement2;<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>\u2026<\/SPAN><\/SPAN><\/P>
\n

END LOOP;<\/SPAN><\/P>
\n

<\/DIV>
\n
<\/DIV>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

v_counterid<\/SPAN>  <\/SPAN><\/SPAN>locations.country_id%type<\/SPAN> := \u2018CA\u2019;<\/SPAN><\/P>
\n

v_loc_id<\/SPAN>  <\/SPAN><\/SPAN>locations.location_id%type<\/SPAN>;<\/SPAN><\/P>
\n

v_new_city<\/SPAN>  <\/SPAN><\/SPAN>locations.city%type<\/SPAN> := \u2018Montreal\u2019;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

select max(<\/SPAN>location_id<\/SPAN>) into <\/SPAN>v_loc_id<\/SPAN> from locations<\/SPAN><\/P>
\n

where <\/SPAN>country_id<\/SPAN> = <\/SPAN>v_countryid<\/SPAN>;<\/SPAN><\/P>
\n

for I in 1..3 loop<\/SPAN><\/P>
\n

  <\/SPAN>insert into locations(<\/SPAN><\/SPAN>location_id<\/SPAN>, city, <\/SPAN>country_id<\/SPAN>)<\/SPAN><\/P>
\n

  <\/SPAN>values((<\/SPAN><\/SPAN>v_loc_id<\/SPAN> + <\/SPAN>i<\/SPAN>), <\/SPAN>v_new_city<\/SPAN>, <\/SPAN>v_countryid<\/SPAN>);<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

– FOR Loop \uaddc\uce59<\/P>
\n

\u00a7<\/SPAN><\/SPAN>loop <\/SPAN>\uc548\uc5d0 \uc788\ub294 \uce74\uc6b4\ud130\ub9cc \ucc38\uc870 \ud560 \uac83<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uce74\uc6b4\ud130\ub97c \ud560\ub2f9 \ub300\uc0c1\uc73c\ub85c \ucc38\uc870\ud558\uc9c0 \ub9d0 \uac83<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>loop <\/SPAN>\uc0c1\ud55c\uc774\ub098 \ud558\ud55c\uc740 <\/SPAN>null <\/SPAN>\uc774\uba74 \uc548\ub41c\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n

 <\/P>
\n

G. Loop \uc758 \uad8c\uc7a5 \uc0ac\uc6a9\ubc95<\/P>
\n

\u00a7<\/SPAN><\/SPAN>loop <\/SPAN>\uc548\uc758 \ubb38\uc7a5\uc774 \uc801\uc5b4\ub3c4 \ud55c\ubc88 \uc2e4\ud589 \ub418\uc5b4\uc57c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 <\/SPAN>Basic<\/SPAN> <\/SPAN>loop <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub9e4\ubc88 \ubc18\ubcf5\uc744 \uc2dc\uc791\ud560 \ub54c\ub9c8\ub2e4 \uc870\uac74\uc774 \ud3c9\uac00 \ub418\uc5b4\uc57c \ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 <\/SPAN>WHILE Loop <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ubc18\ubcf5 \ud69f\uc218\ub97c \uc54c \uc218 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 <\/SPAN>FOR Loop <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n

 <\/P>
\n

H. \uc911\ucca9 loop \ubc0f label<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\ub2e4\uc911 \ub808\ubca8\ub85c <\/SPAN>loop<\/SPAN>\ub97c \uc911\ucca9\uc2dc\ud0ac \uc218 \uc788\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ube14\ub85d\uacfc <\/SPAN>loop<\/SPAN>\uc758 \uad6c\ubd84\uc5d0 <\/SPAN>label<\/SPAN>\uc744 \uc0ac\uc6a9\ud55c\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>label<\/SPAN>\uc744 \ucc38\uc870\ud558\ub294 <\/SPAN>EXIT <\/SPAN>\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc678\ubd80 <\/SPAN>loop<\/SPAN>\ub97c \uc885\ub8cc\ud55c\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

v_outerc<\/SPAN> number := 1;<\/SPAN><\/P>
\n

v_innerc<\/SPAN> number := 1;<\/SPAN><\/P>
\n

v_result<\/SPAN> number;<\/SPAN><\/P> <\/SPAN>
\n

begin<\/SPAN><\/P>
\n

<<<\/SPAN>outer_loop<\/SPAN>>><\/SPAN><\/P>
\n

loop<\/SPAN><\/P>
\n

v_outerc<\/SPAN>:= v_outerc+1;<\/SPAN><\/P>
\n

  <\/SPAN>     <\/SPAN>exit when <\/SPAN><\/SPAN>v_outerc<\/SPAN>>15;<\/SPAN><\/P>
\n

<<<\/SPAN>inner_loop<\/SPAN>>><\/SPAN><\/P>
\n

loop<\/SPAN><\/P>
\n

exit <\/SPAN>outer_loop<\/SPAN> when <\/SPAN>v_outerc<\/SPAN> > 9;<\/SPAN><\/P>
\n

v_result<\/SPAN> := <\/SPAN>v_outerc<\/SPAN> * <\/SPAN>v_innerc<\/SPAN>;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(<\/SPAN>v_outerc<\/SPAN> || \u2018 * \u2018 || <\/SPAN>v_innerc<\/SPAN> || \u2018 = \u2018 || <\/SPAN>v_result<\/SPAN>);<\/SPAN><\/P>
\n

v_innerc<\/SPAN> := <\/SPAN>v_innerc<\/SPAN> + 1;<\/SPAN><\/P>
\n

exit when <\/SPAN>v_innerc<\/SPAN> > 9;<\/SPAN><\/P>
\n

end loop <\/SPAN>inner_loop<\/SPAN>;<\/SPAN><\/P>
\n

v_innerc<\/SPAN> := 1;<\/SPAN><\/P>
\n

end loop <\/SPAN>outer_loop<\/SPAN>;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/DIV>
\n

 <\/P>
\n

I. CONTINUE<\/P><\/p>\n

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>\uc815\uc758<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub2e4\uc74c <\/SPAN>loop <\/SPAN>\ubc18\ubcf5\uc744 \uc2dc\uc791\ud558\ub294 \uae30\ub2a5\uc744 \ucd94\uac00<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud504\ub85c\uadf8\ub798\uba38\uc5d0\uac8c \uc81c\uc5b4\ub97c \ub2e4\uc74c \ub8e8\ud504 \ubc18\ubcf5\uc73c\ub85c \uc804\uc774\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>EXIT <\/SPAN>\ubb38\uc5d0 \ub300\ud55c \uc758\ubbf8\uc640 \ubcd1\ub82c \uad6c\uc870\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc774\uc810<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud504\ub85c\uadf8\ub798\ubc0d \ud504\ub85c\uc138\uc2a4\ub97c \uc6a9\uc774\ud558\uac8c \ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>CONTINUE <\/SPAN>\ubb38\uc744 <\/SPAN>\uc2dc\ubbac\ub808\uc774\ud2b8<\/SPAN> \ud558\ub294 \uc774\uc804 \ud504\ub85c\uadf8\ub798\ubc0d \ud574\uacb0\ucc45\ubcf4\ub2e4 \ub2e4\uc18c \uc131\ub2a5\uc774 \ud5a5\uc0c1 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n

 <\/P>
\n

ex)<\/P>
\n

1)<\/P>
\n

<\/P>
\n

declare<\/SPAN><\/P>
\n

v_total<\/SPAN> <\/SPAN>simple_integer<\/SPAN> := 0;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

for <\/SPAN>i<\/SPAN> in 1..10 loop<\/SPAN><\/P>
\n

v_total<\/SPAN> := <\/SPAN>v_total<\/SPAN> + <\/SPAN>i<\/SPAN>;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018Total is: \u2018 || <\/SPAN>v_total<\/SPAN>);<\/SPAN><\/P>
\n

continue when <\/SPAN>i<\/SPAN> > 5;<\/SPAN><\/P>
\n

v_total<\/SPAN> := <\/SPAN>v_total<\/SPAN> + <\/SPAN>i<\/SPAN>;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018Out of Loop Total is: \u2018|| <\/SPAN>v_total<\/SPAN>);<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/P>
\n

2)<\/P>
\n

declare<\/SPAN><\/P>
\n

v_total<\/SPAN> number := 0;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

<<before>><\/SPAN><\/P>
\n

for <\/SPAN>i<\/SPAN> in 1..10 loop<\/SPAN><\/P>
\n

v_total<\/SPAN> := <\/SPAN>v_total<\/SPAN> + 1;<\/SPAN><\/P>
\n

dbms_output.put_line<\/SPAN>(\u2018Total is : \u2018 || <\/SPAN>v_total<\/SPAN>);<\/SPAN><\/P>
\n

for j in 1..10 loop<\/SPAN><\/P>
\n

continue before when I + j > 5;<\/SPAN><\/P>
\n

v_total<\/SPAN> := <\/SPAN>v_total<\/SPAN> + 1;<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end loop;<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

<\/P>
\n

3)<\/P>
\n

begin<\/SPAN>
   <\/SPAN><\/SPAN>for <\/SPAN>i<\/SPAN> in <\/SPAN>reverse 1 .. 10 <\/SPAN>loop<\/SPAN>
      <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN> (<\/SPAN>lpad<\/SPAN> <\/SPAN>(‘*’, <\/SPAN>i<\/SPAN>, <\/SPAN>‘*’));<\/SPAN>
   <\/SPAN><\/SPAN>end loop;<\/SPAN>
<\/SPAN>end;<\/SPAN><\/P>
\n

================================================<\/SPAN><\/P>
\n

declare<\/SPAN><\/P>
\n

        <\/SPAN><\/SPAN>cnt<\/SPAN>     <\/SPAN>number :=1;<\/SPAN><\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

        <\/SPAN>while <\/SPAN><\/SPAN>cnt<\/SPAN> <= 10 loop<\/SPAN><\/P>
\n

                <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN> (<\/SPAN>lpad<\/SPAN>(‘*’,(11-cnt),’*’));<\/SPAN><\/P>
\n

                <\/SPAN><\/SPAN>cnt<\/SPAN> := <\/SPAN>cnt<\/SPAN> + 1;<\/SPAN><\/P>
\n

        <\/SPAN>end loop;<\/SPAN><\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

<\/P><\/p>\n

 <\/p>\n

 <\/P>
\n

 <\/P>
\n

 <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

5. PL\/SQL \uc81c\uc5b4\uad6c\uc870 \uc791\uc131   A. IF Statement \u00a7Syntax IF condition THEN statements; [ELSIF condition THEN statements;] [ELSE statements;] END IF; ex) 1) \uac04\ub2e8\ud55c IF \ubb38 DECLARE v_myage number := 30; BEGIN IF v_myage < 11 THEN DBMS_OUTPUT.PUT_LINE(\u2018 I am a child \u2018); END IF; END; \/ 2) if then else \ubb38 declare v_myage number […]<\/p>\n","protected":false},"author":1,"featured_media":1243,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile2.uf.26407A365689319A03FB0B.png?fit=124%2C165","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1242"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1242"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1242\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1243"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1242"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}