{"id":1220,"date":"2016-01-03T13:35:32","date_gmt":"2016-01-03T13:35:32","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1220"},"modified":"2016-01-03T13:35:32","modified_gmt":"2016-01-03T13:35:32","slug":"1-plsql-%ec%86%8c%ea%b0%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1220","title":{"rendered":"1. PL\/SQL \uc18c\uac1c"},"content":{"rendered":"<p><P>1. PL\/SQL \uc18c\uac1c<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">A. &nbsp;PL\/SQL<\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; CLEAR: none\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile23.uf.247F0C4156891FD30B46EC.png?resize=616%2C235\" class=\"aligncenter\" width=\"616\" height=\"235\" filename=\"PL1.png\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>SQL\uc744 \ud655\uc7a5\ud55c \uc808\ucc28\uc801 \uc5b8\uc5b4(Procedural Language)<\/LI><br \/>\n<LI>\uad00\uacc4\ud615 DB\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 Oracle \ud45c\uc900 \ub370\uc774\ud130 \uc561\uc138\uc2a4 \uc5b8\uc5b4<\/LI><br \/>\n<LI>\ucf54\ub4dc \uc2e4\ud589 \ub2e8\uc704\uc5d0 \ube14\ub85d \uad6c\uc870 \uc81c\uacf5<\/LI><br \/>\n<LI>\uc26c\uc6b4 \ucf54\ub4dc \uc720\uc9c0 \uad00\ub9ac \uac00\ub2a5<\/LI><br \/>\n<LI>\ud504\ub85c\uc2dc\uc800 \uc0dd\uc131\uc790 \uc81c\uacf5<\/LI><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>\ubcc0\uc218, \uc0c1\uc218 \ubc0f \ub370\uc774\ud130 \uc720\ud615<\/LI><br \/>\n<LI>\uc870\uac74\ubb38 \ubc0f \ub8e8\ud504\uc640 \uac19\uc740 \uc81c\uc5b4 \uad6c\uc870<\/LI><br \/>\n<LI>\uc7ac\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ud504\ub85c\uadf8\ub7a8 \ub2e8\uc704<\/LI><\/UL><\/UL><br \/>\n<P style=\"MARGIN-LEFT: 2em\">B. PL\/SQL \ub7f0\ud0c0\uc784 \uad6c\uc870<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&nbsp;<\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; MARGIN-LEFT: 2em; CLEAR: none\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile5.uf.2247ED465689209B302E89.png?resize=502%2C348\" class=\"aligncenter\" width=\"502\" height=\"348\" filename=\"PL2.png\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; MARGIN-LEFT: 2em; CLEAR: none\">&nbsp;<\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: left; MARGIN-LEFT: 2em; CLEAR: none\">C. PL\/SQL \uc7a5\uc810<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&nbsp;<\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; MARGIN-LEFT: 2em; CLEAR: none\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile30.uf.2247ED46568920C73146EB.png?resize=402%2C352\" class=\"aligncenter\" width=\"402\" height=\"352\" filename=\"PL3.png\" filemime=\"image\/jpeg\" style=\"HEIGHT: 352px; WIDTH: 402px\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>SQL &amp; \ud504\ub85c\uc2dc\uc800 \uc0dd\uc131\uc790 \ud1b5\ud569<\/LI><br \/>\n<LI>\uc131\ub2a5 \ud5a5\uc0c1<\/LI><br \/>\n<LI>\ubaa8\ub4c8\uc2dd \ud504\ub85c\uadf8\ub7a8 \uac1c\ubc1c<\/LI><br \/>\n<LI>Oracle \ud234\uacfc\uc758 \ud1b5\ud569<\/LI><br \/>\n<LI>\uc774\uc2dd\uc131<\/LI><br \/>\n<LI>\uc608\uc678\ucc98\ub9ac<\/LI><\/UL><br \/>\n<P style=\"MARGIN-LEFT: 2em\">D. PL\/SQL \ube14\ub85d \uad6c\uc870<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&nbsp;<\/P><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; MARGIN-LEFT: 2em; CLEAR: none\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile2.uf.21348A3F568921230E2119.png?resize=553%2C259\" class=\"aligncenter\" width=\"553\" height=\"259\" filename=\"PL4.png\" filemime=\"image\/jpeg\" style=\"HEIGHT: 259px; WIDTH: 553px\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">DECLARE (\uc120\uc5b8)<\/P><br \/>\n<P style=\"MARGIN-LEFT: 4em\">&#8211; \uc120\ud0dd\uc0ac\ud56d<\/P><br \/>\n<P style=\"MARGIN-LEFT: 4em\">&#8211; \ubcc0\uc218, \ucee4\uc11c, \uc720\uc800 \uc815\uc758 \uc608\uc678 \uc120\uc5b8<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">BEGIN &#8212; END (\uc2e4\ud589) ** \ud544\uc218**<\/P><br \/>\n<P style=\"MARGIN-LEFT: 4em\">&#8211; SQL \ubb38<\/P><br \/>\n<P style=\"MARGIN-LEFT: 4em\">&#8211; PL\/SQL \ubb38<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">EXCEPTION (\uc608\uc678\ucc98\ub9ac)<\/P><br \/>\n<P style=\"MARGIN-LEFT: 4em\">&#8211; \uc608\uc678 \ubc1c\uc0dd \uc2dc \uc218\ud589\ud560 \uc791\uc5c5<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&nbsp;<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">E. PL\/SQL \ube14\ub85d \uc720\ud615<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&nbsp;<\/P><br \/>\n<P style=\"FLOAT: left; MARGIN-LEFT: 2em; CLEAR: both\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile28.uf.2551CD425689219814EDE0.png?resize=165%2C234\" class=\"aligncenter\" width=\"165\" height=\"234\" filename=\"PL5.png\" filemime=\"image\/jpeg\" style=\"HEIGHT: 234px; WIDTH: 165px; MARGIN-RIGHT: 10px\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">[\ud504\ub85c\uc2dc\uc800]<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">SQL \ub610\ub294&nbsp;PL\/SQL \ubb38\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 &#8220;\uba85\uba85\ub41c \uac1d\uccb4&#8221;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P style=\"FLOAT: left; CLEAR: both\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile25.uf.211B7340568921D62F0B82.png?resize=170%2C234\" class=\"aligncenter\" width=\"170\" height=\"234\" filename=\"PL6.png\" filemime=\"image\/jpeg\" style=\"HEIGHT: 234px; WIDTH: 170px; MARGIN-RIGHT: 10px\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P style=\"FLOAT: left; CLEAR: both\"><\/P><br \/>\n<P>[\ud568\uc218]<\/P><br \/>\n<P>SQL \ub610\ub294 PL\/SQL\ubb38\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 &#8220;\uba85\uba85\ub41c \uac1d\uccb4&#8221;<\/P><br \/>\n<P>\uc9c0\uc815\ub41c \ub370\uc774\ud130 \uc720\ud615\uc758 RETURN \uac12 \ubc18\ud658<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P style=\"FLOAT: left; CLEAR: both\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile30.uf.22669B445689222D163B53.png?resize=177%2C234\" class=\"aligncenter\" width=\"177\" height=\"234\" filename=\"PL7.png\" filemime=\"image\/jpeg\" style=\"HEIGHT: 234px; WIDTH: 177px; MARGIN-RIGHT: 10px\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P style=\"FLOAT: left; CLEAR: both\"><\/P><br \/>\n<P>[ANONYMOUS(\uc775\uba85 \ube14\ub85d)]<\/P><br \/>\n<P>\uc774\ub984\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ube14\ub85d<\/P><br \/>\n<P>\uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc778\ub77c\uc778\uc73c\ub85c \uc120\uc5b8,<\/P><br \/>\n<P>\uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc774 \uc2e4\ud589 \ub420 \ub54c\ub9c8\ub2e4 \ucef4\ud30c\uc77c<\/P><br \/>\n<P>DB\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc74c, \ub7f0\ud0c0\uc784\uc5d0 PL\/SQL\uc5d4\uc9c4\uc73c\ub85c \uc804\ub2ec\ub418\uc5b4 \uc2e4\ud589<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>[\uc11c\ube0c \ud504\ub85c\uadf8\ub7a8]<\/P><br \/>\n<P>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uba85\uba85\ub41c PL\/SQL \ube14\ub85d<\/P><br \/>\n<P>\ud544\uc694\uc5d0 \ub530\ub77c \uc5b8\uc81c\ub4e0 \ud638\ucd9c \uac00\ub2a5<\/P><br \/>\n<P>PROCEDURE \ud639\uc740 \ud568\uc218\ub85c \uc120\uc5b8 \uac00\ub2a5<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&#8211; \uc77c\ubc18\uc801 \uc791\uc5c5 \uc218\ud589 =&gt; PROCEDURE<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">&#8211; \uac12 \uacc4\uc0b0 \ud639\uc740 RETURN \uac12 \ubc18\ud658 =&gt; \ud568\uc218<\/P><br \/>\n<P>\uc11c\ubc84 \ub610\ub294 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \ub808\ubca8\uc5d0\uc11c \uc800\uc7a5 \ud560 \uc218 \uc788\uc74c<\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">F. PL\/SQL BLOCK Example<\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">DECLARE<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp;&nbsp; <\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">v_fname<\/SPAN><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp; <\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">VARCHAR2(20)<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">;<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">BEGIN<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp;<\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp; <\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">SELECT<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> <\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">first_name<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp;&nbsp; <\/SPAN><SPAN style=\"FONT-SIZE: 9pt\">INTO<\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> <\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">v_fname<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> <\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp;&nbsp; <\/SPAN><SPAN style=\"FONT-SIZE: 9pt\">FROM<\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> employees<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp;<\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 20pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"><SPAN style=\"FONT-SIZE: 9pt; mso-spacerun: yes\">&nbsp; <\/SPAN><\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">WHERE<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\"> <\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">employee_id<\/SPAN><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">=100;<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">END;<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-BOTTOM: 0pt; unicode-bidi: embed; DIRECTION: ltr; TEXT-ALIGN: left; MARGIN-LEFT: 0in; MARGIN-TOP: 0pt; language: ko; mso-line-break-override: none; punctuation-wrap: hanging\"><SPAN style=\"FONT-SIZE: 9pt; FONT-FAMILY: Verdana; FONT-WEIGHT: bold; COLOR: black; language: en-US; mso-ascii-font-family: Verdana; mso-fareast-font-family: Verdana; mso-bidi-font-family: Verdana; mso-color-index: 13; mso-font-kerning: 12.0pt; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: dark1; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%\">\/<\/SPAN><\/P><br \/>\n<P style=\"MARGIN-LEFT: 2em\">G. PL\/SQL BLOCK \ucd9c\ub825 \ud65c\uc131\ud654<\/P><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>SELECT \ud55c \uacb0\uacfc \uac12\uc774 v_fname\uc5d0 \uc800\uc7a5\ub418\uc5c8\uc9c0\ub9cc \ucd9c\ub825\ub418\uc9c0 \uc54a\uc74c<\/LI><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>1. SET SERVEROUTPUT ON<\/LI><br \/>\n<LI>\ubbf8\ub9ac \uc815\uc758\ub41c ORACLE \ud328\ud0a4\uc9c0\uc640 \ud574\ub2f9 \ud504\ub85c\uc2dc\uc800\ub97c \uc775\uba85 \ube14\ub85d\uc5d0 \uc0ac\uc6a9<\/LI><br \/>\n<UL style=\"LIST-STYLE-TYPE: square\"><br \/>\n<LI>=&gt; DBMS_OUTPUT.PUT_LINE<\/LI><\/UL><\/UL><\/UL><br \/>\n<P style=\"FLOAT: none; TEXT-ALIGN: center; CLEAR: none\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile7.uf.2332513F568923841DCD55.png?resize=640%2C308\" class=\"aligncenter\" width=\"640\" height=\"308\" filename=\"PL9.png\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/P><br \/>\n<P>&nbsp;<\/P><br \/>\n<P>&nbsp;<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. PL\/SQL \uc18c\uac1c A. &nbsp;PL\/SQL SQL\uc744 \ud655\uc7a5\ud55c \uc808\ucc28\uc801 \uc5b8\uc5b4(Procedural Language) \uad00\uacc4\ud615 DB\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 Oracle \ud45c\uc900 \ub370\uc774\ud130 \uc561\uc138\uc2a4 \uc5b8\uc5b4 \ucf54\ub4dc \uc2e4\ud589 \ub2e8\uc704\uc5d0 \ube14\ub85d \uad6c\uc870 \uc81c\uacf5 \uc26c\uc6b4 \ucf54\ub4dc \uc720\uc9c0 \uad00\ub9ac \uac00\ub2a5 \ud504\ub85c\uc2dc\uc800 \uc0dd\uc131\uc790 \uc81c\uacf5 \ubcc0\uc218, \uc0c1\uc218 \ubc0f \ub370\uc774\ud130 \uc720\ud615 \uc870\uac74\ubb38 \ubc0f \ub8e8\ud504\uc640 \uac19\uc740 \uc81c\uc5b4 \uad6c\uc870 \uc7ac\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ud504\ub85c\uadf8\ub7a8 \ub2e8\uc704 B. PL\/SQL \ub7f0\ud0c0\uc784 \uad6c\uc870 &nbsp; &nbsp; C. PL\/SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1221,"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.21348A3F568921230E2119.png?fit=820%2C359","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1220"}],"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=1220"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1220\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1221"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1220"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}