{"id":820,"date":"2022-01-21T18:16:02","date_gmt":"2022-01-21T09:16:02","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=820"},"modified":"2022-01-21T18:16:02","modified_gmt":"2022-01-21T09:16:02","slug":"connect-by-start-with-bom","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2022\/01\/21\/connect-by-start-with-bom\/","title":{"rendered":"connect by start with bom"},"content":{"rendered":"<div id=\"cContentBody\" class=\"cContentBody\">\n<div id=\"div_${article.articleNo}\">\n<div class=\"tt_article_useless_p_margin contents_style\">\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: small;\">\uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc758 &#8216;connect by start with&#8217; \uc5d0\uc11c \ubcf4\uae30 \uc5b4\ub824\uc6b4<br \/>\n\uc911\ubcf5\uac00\uc9c0\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uc758 \ub204\uc801\ud658\uc0b0\ub7c9\uc744 \uad6c\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/span><br \/>\n<span style=\"font-size: small;\">\/* 1. BOM\ud14c\uc774\ube14 *\/<br \/>\nCREATE TABLE BOM (<br \/>\nPartNo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(2),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* PartNo *\/<br \/>\nPartNoM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(10),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* \ubd80\ubaa8PARTNO *\/<br \/>\nQnty\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(10)\u00a0\u00a0 NOT NULL,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* \ub2e8\uc704\ub2f9\uc18c\uc694\ub7c9 *\/<br \/>\nCONSTRAINT pk_g_BOM PRIMARY KEY (PartNo, PartNoM));<\/p>\n<p>\/* 2. DATA *\/<br \/>\nINSERT INTO BOM VALUES (&#8216;X&#8217;,&#8217;*&#8217;,1);<br \/>\nINSERT INTO BOM VALUES (&#8216;A&#8217;,&#8217;X&#8217;,1);<br \/>\nINSERT INTO BOM VALUES (&#8216;B&#8217;,&#8217;X&#8217;,2);<br \/>\nINSERT INTO BOM VALUES (&#8216;C&#8217;,&#8217;B&#8217;,3);<br \/>\nINSERT INTO BOM VALUES (&#8216;E&#8217;,&#8217;C&#8217;,3);<br \/>\nINSERT INTO BOM VALUES (&#8216;F&#8217;,&#8217;C&#8217;,4);<br \/>\nINSERT INTO BOM VALUES (&#8216;I&#8217;,&#8217;C&#8217;,5);<br \/>\nINSERT INTO BOM VALUES (&#8216;D&#8217;,&#8217;B&#8217;,4);<br \/>\nINSERT INTO BOM VALUES (&#8216;H&#8217;,&#8217;D&#8217;,2);<br \/>\nINSERT INTO BOM VALUES (&#8216;C&#8217;,&#8217;J&#8217;,6);<br \/>\nINSERT INTO BOM VALUES (&#8216;J&#8217;,&#8217;D&#8217;,4);<br \/>\nINSERT INTO BOM VALUES (&#8216;K&#8217;,&#8217;D&#8217;,3);<\/p>\n<p>\/* 3. \uc124\uba85*\/<br \/>\n\uc774\ub807\uac8c\ub418\uba74<br \/>\nBOM \uc774\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 \uc544\ub798\uc640\uc640\uac19\uc740 \uc790\ub8cc\uac00 \ub4e4\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>SELECT * FROM BOM;<\/p>\n<p>PA PARTNOM\u00a0\u00a0\u00a0 QNTY<br \/>\n&#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\nX\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\nA\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\nB\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nC\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\nE\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\nF\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nI\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\nD\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nH\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nC\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\nJ\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nK\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 rows selected.<\/p>\n<p>\/* 4.\uc6d0\ud558\ub294 \uacb0\uacfc *\/<br \/>\n<\/span><span style=\"font-size: small;\"><span style=\"color: darkblue;\">FUNCTION\uc744 \uc4f0\uc9c0\uc54a\uc740 onE SQL \ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uc5b4\ub0b4\uace0 \uc2f6\ub2f5\ub2c8\ub2e4.<\/p>\n<p>&#8212;- &#8212;&#8212;&#8212;&#8212;- &#8212; &#8212;&#8211; &#8212;&#8212;&#8212;-<br \/>\n1 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n3 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\n4 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18<br \/>\n5 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24<br \/>\n6 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30<br \/>\n7 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8<br \/>\n8 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 H\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16<br \/>\n9 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32<br \/>\n10 &#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192<br \/>\n11 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 576<br \/>\n12 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 768<br \/>\n13 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 960<br \/>\n14 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 K\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24<br \/>\n<\/span>14 rows selected.<\/p>\n<p><\/span><span style=\"font-size: small;\"><span style=\"color: blue;\">\/* 5.\uacb0\uacfc\uc124\uba85 *\/<\/p>\n<p>&#8212;- &#8212;&#8212;&#8212;&#8212;- &#8212; &#8212;&#8211; &#8212;&#8212;&#8212;-<br \/>\n1 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0 \ucd5c\uc0c1\uc704 \uc774\ubbc0\ub85c \uc790\uc2e0\uc758 \uc218\ub7c9<br \/>\n2 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0 \ucd5c\uc0c1\uc704 \uc774\ubbc0\ub85c \uc790\uc2e0\uc758 \uc218\ub7c9<br \/>\n3 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 3*2 = 6<br \/>\n4 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 3*3*2 = 18<br \/>\n5 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 4*3*2 = 24<br \/>\n6 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 5*3*2 = 30<br \/>\n7 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 4*2 = 8<br \/>\n8 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 H\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 2*4*2 = 16<br \/>\n9 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 4*4*2 = 32<br \/>\n10 &#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8J\uc758\uc218\ub7c9*J\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 6*4*4*2 = 192<br \/>\n11 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 576\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8J\uc758\uc218\ub7c9*J\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 3*6*4*4*2 = 576<br \/>\n12 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 768\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8J\uc758\uc218\ub7c9*J\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 4*6*4*4*2 = 768<br \/>\n13 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 960\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8C\uc758\uc218\ub7c9*C\uc758\ubd80\ubaa8J\uc758\uc218\ub7c9*J\uc758\ubd80\ubaa8&#8230;3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 K\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24\u00a0 \uc790\uc2e0\uc758\uc218\ub7c9*\uc790\uc2e0\uc758\ubd80\ubaa8D\uc758\uc218\ub7c9*D\uc758\ubd80\ubaa8B\uc758\uc218\ub7c9 = 3*4*2 = 24<br \/>\n14 rows selected.<br \/>\n<\/span><br \/>\n\/* 6.\uac00\uc815*\/<br \/>\n\uc2e4\uc81c \ud14c\uc774\ube14\uc5d0 \uc874\uc7ac\ud558\ub294 record\ub294 12\uac74\uc778\ub370 \uc21c\uc804\uac1c\ub97c \ud1b5\ud558\uc5ec \uc804\uac1c\ub97c \ud574\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 14\uac74\uc758 \uc790\ub8cc\uac00 \ub098\uc635\ub2c8\ub2e4.<\/p>\n<p>SELECT LPAD(LEVEL, DECODE(LEVEL,1,1,(LEVEL*2)-1),&#8217;.&#8217;) AS LEVELNO,<br \/>\nLEVEL AS LVNO,<br \/>\nPARTNO,<br \/>\nQNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<\/span><\/p>\n<p><span style=\"font-size: small;\">(order siblings by \uceec\ub7fc\uba85)<\/p>\n<p>LEVELNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LVNO\u00a0\u00a0 PA QNTY<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212; &#8212; &#8212;&#8211;<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 B\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 C\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 E\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 F\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 I\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 D\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 H\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 J\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 C\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 E\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 I\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 K\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n14 rows selected.<\/p>\n<p>\uc774\uc720\ub294 \uc790\ub8cc\ub97c \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uba74 \uc544\uc2dc\uaca0\uc9c0\ub9cc<br \/>\n\uc790\ub3d9\ucc28 \ubd80\ud488\uc758 \uc911\uac04\ubd80\ud488\uc5d0 \uc4f0\uc774\ub294 \ubd80\ud488\uc774 \ub610\ub2e4\ub978 \uc911\uac04\ubd80\ud488\uc5d0\uc11c\ub3c4 \uc4f0\uc774\ub4ef\uc774 C \ub85c \uc2dc\uc791\ub418\ub294 \uac00\uc9c0\uac00 \ub450\uad70\ub370\uc5d0\uc11c \uc4f0\uc774\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7f4\uacbd\uc6b0\ub294\u00a0<u>C\ub85c \uc2dc\uc791\ud558\uc5ec \uc5ed\uc804\uac1c\ub97c \ud558\uba74 \uc911\ubcf5\uac00\uc9c0\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4<\/u><\/p>\n<p>SELECT *<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNO=&#8217;C&#8217;<br \/>\nCONNECT BY PRIOR PARTNOM=PARTNO<\/p>\n<p>PA PARTNOM\u00a0\u00a0\u00a0 QNTY<br \/>\n&#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\nC\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\nB\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nX\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\nC\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\nJ\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nD\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nB\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nX\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n8 rows selected.<\/p>\n<p>\uc911\ubcf5\uac00\uc9c0\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 \uac04\ub2e8\ud558\uac8c \uc5ed\uc804\uac1c \uacb0\uacfc\ub97c \uc774\uc6a9\ud574 \ub098\uc624\ub294<br \/>\n\uacb0\uacfc\uac12\uc758 \uacf1 \ub9cc\uc73c\ub85c \ud658\uc0b0\uc218\ub7c9\uc744 \uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n\uc608\ub97c\ub4e4\uc5b4 \ucd5c\ucd08\uc758 \uc790\ub8cc\uc911<br \/>\nINSERT INTO BOM VALUES (&#8216;C&#8217;,&#8217;J&#8217;,6);<br \/>\n\uac00 \uc5c6\ub2e4\uace0 \uac00\uc815\ud574 \ubd05\uc2dc\ub2e4.<\/p>\n<p>\uc5b8\uae09\ud55c \ud55c \ub808\ucf54\ub4dc\ub97c \uc81c\uc678\ud558\uace0 QUERY \ub97c \ub358\uc9c0\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4.<br \/>\nSELECT * FROM BOM;<\/p>\n<p>PA PARTNOM\u00a0\u00a0\u00a0 QNTY<br \/>\n&#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\nX\u00a0 *\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\nA\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\nB\u00a0 X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nC\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\nE\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\nF\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nI\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\nD\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nH\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\nJ\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\nK\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 rows selected.<\/p>\n<p>\uc774\uacbd\uc6b0 \uc21c\uc804\uac1c\ub97c \ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<p>NO\u00a0\u00a0 LEVELNO\u00a0 PA QNTY<br \/>\n&#8212;- &#8212;&#8212;&#8211; &#8212; &#8212;&#8212;&#8212;-<br \/>\n1 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n3 ..2\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n4 &#8230;.3\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n5 &#8230;.3\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n6 &#8230;.3\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n7 ..2\u00a0\u00a0\u00a0\u00a0\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n8 &#8230;.3\u00a0\u00a0\u00a0 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n9 &#8230;.3\u00a0\u00a0\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n10 &#8230;.3\u00a0\u00a0\u00a0 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 rows selected.<\/p>\n<p>\uc704\uc640 \uac19\uc740 \uacbd\uc6b0\uc758 \ud658\uc0b0\uc218\ub7c9\uc744 \uad6c\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uac04\ub2e8\ud569\ub2c8\ub2e4.<\/p>\n<p>SELECT A.LEVELNO,<br \/>\nA.PARTNO,<br \/>\nA.QNTY,<br \/>\n(SELECT\u00a0 EXP(SUM(LN(B.QNTY)))<br \/>\nFROM\u00a0\u00a0\u00a0 BOM B<br \/>\nSTART WITH B.PARTNO = A.PARTNO<br \/>\nCONNECT BY PRIOR PARTNOM=PARTNO<br \/>\n) QTY<br \/>\nFROM (SELECT LPAD(LEVEL, DECODE(LEVEL,1,1,(LEVEL*2)-1),&#8217;.&#8217;) AS LEVELNO,<br \/>\nLEVEL AS LVNO,<br \/>\nPARTNO,<br \/>\nQNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM)\u00a0 A ;<\/p>\n<p>\uacb0\uacfc<\/p>\n<p>LEVELNO\u00a0 PA QNTY\u00a0 QTY<br \/>\n&#8212;&#8212;&#8211; &#8212; &#8212;&#8211; &#8212;&#8211;<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 A\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0 1<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 B\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0 2<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0 C\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0 6<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 E\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 18<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 F\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 24<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 I\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0 30<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0 D\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0 8<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 H\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0 16<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 J\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 32<br \/>\n&#8230;.3\u00a0\u00a0\u00a0 K\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 24<br \/>\n10 rows selected<\/p>\n<p>\uc989 \ud2b9\uc815\ud55c \ubd80\ud488 \ud558\ub098\uc5d0 \ub300\ud574 \uc5ed\uc804\uac1c\ub97c \ud574 \ub098\uac00\ub354\ub77c\ub3c4 \uc911\ubcf5 \uac00\uc9c0\uac00 \ubc1c\uc0dd\ud560 \uc5fc\ub824\uac00 \uc5c6\uc73c\ubbc0\ub85c<br \/>\n\ub2e8\uc21c\ud55c QUERY \ub9cc\uc73c\ub85c\ub3c4 \uac01 \ubd80\ud488\uc758 \ud658\uc0b0 \uc0b0\ucd9c\ub7c9\uc744 \uad6c\ud558\ub294\ub370 \uc544\ubb34\ub7f0 \uc9c0\uc7a5\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p><\/span><span style=\"font-size: small;\"><span style=\"color: darkgreen;\">\ud558\uc9c0\ub9cc<br \/>\nINSERT INTO BOM VALUES (&#8216;C&#8217;,&#8217;J&#8217;,6);<br \/>\n\ub97c \ud1b5\ud558\uc5ec \uc911\ubcf5\uac00\uc9c0\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74<br \/>\n\uc704\uc640 \uac19\uc774 \uac04\ub2e8\ud55c \ubb38\uc7a5\uc73c\ub85c \ud574\uacb0\ud560 \uae38\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub7f4\uacbd\uc6b0\ub294 \uc811\uadfc\ubc29\uc2dd\uc744 \uadfc\ubcf8\uc801\uc73c\ub85c \ub2e4\uc2dc \uc0dd\uac01\ud574\ubd10\uc57c\ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/p>\n<p>\/* 7.\ubb38\uc81c\ud480\uc774*\/<br \/>\n\ud604\uc7ac \ud558\uace0\uc790\ud558\ub294\ubc29\uc2dd\uc740 \uc5b4\ub5a4\ubc29\uc2dd\uc744 \uc368\uc11c\ub77c\ub3c4\u00a0<\/span><span style=\"font-size: small;\"><span style=\"color: blue;\"><u>\ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc9c0\uc54a\uace0<br \/>\n\ud558\ub098\uc758 SQL \uc5d0\uc11c \uc911\ubcf5\uac00\uc9c0 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uace0 \ub204\uc801\ud658\uc0b0 \uc0b0\ucd9c\ub7c9\uc744 \uad6c\ud558\ub294\u00a0<\/u><\/span>\uac81\ub2c8\ub2e4.<\/p>\n<p><\/span><span style=\"font-size: small;\"><strong><span style=\"color: darkviolet;\">\ub2e8\uacc41.<br \/>\n<\/span><\/strong>\uc911\uc810\uc801\uc73c\ub85c \uc0dd\uac01\ud574 \ubcfc\uac83\uc740 \uc5b4\ub5a4\uc2dd\uc73c\ub85c \uc911\ubcf5\uac00\uc9c0\ub97c \ud53c\ud574\uc11c \uc790\uc2e0\ub9cc\uc758 \uc0c1\uc704 \ubd80\ud488\ub4e4\uc744 \ucc3e\uc544\ub0bc\uac83\uc778\uac00 \uc785\ub2c8\ub2e4.<\/p>\n<p>\ud2b9\uc815\ubd80\ud488\uc744 \uae30\uc900\uc73c\ub85c \uc0dd\uac01\ud574\ubcfc\ub54c \uc790\uc2e0\uc758 \uc0c1\uc704\ubd80\ud488\uc740 \uc5b4\ub5a4 \uacf5\ud1b5\uc801\uc778 \ud2b9\uc9d5\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uccab\uc9f8 \ub808\ubca8\uc774 \uc790\uc2e0\ubcf4\ub2e4 \ub192\ub2e4.<br \/>\n\uc989 \ud2b9\uc815\ubd80\ud488\uc744 \uae30\uc900\uc73c\ub85c \ubcfc\ub54c \ub808\ubca8\uc758 \uc22b\uc790\uac00 \uc790\uc2e0\ubcf4\ub2e4 \ub0ae\uc740\uacbd\uc6b0\ub9cc\uc774 \uc790\uc2e0\uc758 \ubd80\ubaa8\ub808\ubca8\uc774 \ub420 \ud6c4\ubcf4\uc785\ub2c8\ub2e4.<br \/>\n\ub458\uc9f8 \uc804\uac1c\uac00 \uc81c\ub300\ub85c \uc774\ub8e8\uc5b4\uc84c\ub2e4\uba74 \uc790\uc2e0\ubcf4\ub2e4 \ud56d\uc0c1 \uc0c1\ub2e8\uc5d0\uc11c \uc804\uac1c\uac00 \uc774\ub8e8\uc5b4\uc9c4\ub2e4 \uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub807\uac8c \ub450\uac00\uc9c0 \uc870\uac74\uc73c\ub85c\ub294 \uc644\ubcbd\ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc77c\ucc28\uc801\uc778 \ud544\ud130\ub9c1\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub807\uac8c \uc77c\ucc28\uc801\uc778 \ud544\ud130\ub9c1\uc744 \uc704\ud574 \ud544\uc694\ud55c \ucffc\ub9ac\uc5d0\ub294 \uc804\uac1c \uacb0\uacfc\uc640 \ud568\uaed8 \uc790\uc2e0\uc758 ROWNUM \uc774 \ud3ec\ud568\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>SQL\uacfc \uacb0\uacfc\ub294\u00a0 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br \/>\nSQL<br \/>\nSELECT NO,PARTNO,<br \/>\nLEN<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,<br \/>\nLEV LEN<br \/>\nFROM\u00a0 (<br \/>\nSELECT LEVEL LEV,PARTNO<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<\/p>\n<p>\uacb0\uacfc<br \/>\nNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN<br \/>\n&#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;-<br \/>\n1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n14 rows selected.<\/p>\n<p><\/span><span style=\"font-size: small;\"><strong><span style=\"color: mediumslateblue;\">\ub2e8\uacc42.<br \/>\n<\/span><\/strong>\u00a0\u00a0 \ub450\ubc88\uc9f8 \ub2e8\uacc4\ub294 \uc704\uc758 \uacb0\uacfc\ub97c \uc774\uc6a9\ud574\uc11c \uc790\uc2e0\ubcf4\ub2e4 LEVEL(\uc989 LEN) \uc774 \uc791\uc73c\uba74\uc11c<br \/>\n\ub3d9\uc2dc\uc5d0 \uc790\uc2e0\ubcf4\ub2e4 \uba3c\uc800 \uc804\uac1c\uac00 \uc774\ub8e8\uc5b4\uc9c4(\uc989 NO \uac00 \uc790\uc2e0\ubcf4\ub2e4 \uc791\uc740) \uc790\ub8cc\ub9cc\uc744 \ubf51\uc544\ub0b4\ub294 \uc77c\uc785\ub2c8\ub2e4.<br \/>\n\uadf8\ub7ec\uae30 \uc704\ud574\uc120 \uc704\uc758 \uacb0\uacfc\ub97c \uc774\uc6a9\ud574 \ubd80\ub4f1\ud638\uc870\uc778\uc744 \ub3d9\uc77c\ud55c \uacb0\uacfc\uc5d0 \uac78\uc5b4\uc918\uc57c \ud560\uac81\ub2c8\ub2e4.<\/p>\n<p>SQL\uacfc \uacb0\uacfc\ub294\u00a0 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br \/>\nSQL<br \/>\nSELECT A.NO,A.PARTNO,A.LEN,<br \/>\nB.NO,B.PARTNO,B.LEN<br \/>\nFROM (SELECT NO,PARTNO,<br \/>\nLEN<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,<br \/>\nLEV LEN<br \/>\nFROM\u00a0 (<br \/>\nSELECT LEVEL LEV,PARTNO<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) A,<br \/>\n(SELECT NO,PARTNO,<br \/>\nLEN,QNTY<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,<br \/>\nLEV LEN,QNTY<br \/>\nFROM\u00a0 (<br \/>\nSELECT LEVEL LEV,PARTNO,QNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) B<br \/>\nWHERE B.NO(+)\u00a0 &lt; A.NO<br \/>\nAND\u00a0\u00a0 B.LEN(+) &lt; A.LEN<\/p>\n<p>\uacb0\uacfc<br \/>\nNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN<br \/>\n&#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;-<br \/>\n1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n66 rows selected.<\/p>\n<p>\ubc8c\uc368 SQL \uc774 \uae38\uc5b4\uc9c4\ub4ef\ud55c \ub290\ub08c\uc774\uc9c0\ub9cc \uc0b4\ud3b4\ubcf4\uba74 \uac04\ub2e8\ud569\ub2c8\ub2e4.<br \/>\n\ub2e8\uacc41\uc5d0\uc11c \ub098\uc628 SQL \uc744 \ub450\ubc88\uc368\uc11c \uc11c\ub85c NON-EQUI \uc870\uc778\uc744<br \/>\n\uc704\uc5d0\uc11c \uc5b8\uae09\ud55c\ub300\ub85c \uac78\uc5b4\uc900\uac81\ub2c8\ub2e4.<br \/>\n\uc870\uac74\uc774<br \/>\nWHERE B.NO(+)\u00a0 &lt; A.NO<br \/>\nAND\u00a0\u00a0 B.LEN(+) &lt; A.LEN<br \/>\n\uc774\ub807\uac8c \ub418\uc5b4 \uc788\ub294\uac8c \uc804\ubd80\uc785\ub2c8\ub2e4.<br \/>\nOUTER \uae30\ud638\uac00 \ubd99\uc740 \uc774\uc720\ub294 \uc124\uba85\uc548\ud574\ub3c4 \uc544\uc2dc\uaca0\uc9c0\ub9cc<br \/>\nA\ud14c\uc774\ube14\uc744 \uae30\uc900\uc73c\ub85c \uc7a1\uace0 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<br \/>\n\uc870\uc778\uc758 \ud2b9\uc131\uc0c1 OUTER \uac00 \uc544\ub2cc\uacbd\uc6b0\ub294 \uc870\uc778\uc774 \uac78\ub9ac\ub294 \uac12\uc774 \uc591\ucabd \ub370\uc774\ud0c0\uc14b\uc5d0 \ubaa8\ub450 \uc874\uc7ac\ud574\uc57c\ud558\uae30\ub54c\ubb38\uc5d0<br \/>\n\ucd5c\uc0c1\uc704\uc778 A,B \ub450\uac1c\uc758 PART \uac00 \ube60\uc9d1\ub2c8\ub2e4.<br \/>\n\uc774\ub97c \ub9c9\uae30\uc704\ud574 OUTER \uc870\uc778\uc774 \uc774\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc911\uc694\ud55c\uac74 \uc5ec\uae30\uae4c\uc9c0\uc758 \uacb0\uacfc\ub97c \ubd84\uc11d\ud558\ub294\uac81\ub2c8\ub2e4.<br \/>\n\uacb0\uacfc\uac00 \ub9ce\uc544\uc9c4 \uc774\uc720\ub294 14\uac1c\uc758 \uac01 \uc21c \uc804\uac1c\ub41c PART \ub9c8\ub2e4<br \/>\n\uc790\uc2e0\uc758 \uc9c1\uacc4 \uc0c1\uc704\uac00 \ub420 \uc218 \uc788\ub294 \ud6c4\ubcf4\ub4e4\uacfc \uc870\uc778\uc774 \uc774\ub8e8\uc5b4\uc84c\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<br \/>\n\uc774 \uacb0\uacfc\uac00 \uc9c1\uacc4 \uc0c1\uc704 \ud6c4\ubcf4\ub4e4\uc774 \ub9de\ub294\ub2e4\uba74 \ub2e8\uc21c\ud788 A.NO \ubcc4\ub85c GROUP BY \ub9cc \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4.<br \/>\n\ud558\uc9c0\ub9cc \uc704\uc758 \uacb0\uacfc\ub97c \ubcf4\uba74 \uc54c \uc218 \uc788\ub4ef\uc774<br \/>\n\uc5ec\uae30\uc11c \ud55c\ub2e8\uacc4 \ub354 \ud544\ud130\ub9c1\uc744 \ud574\uc918\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc5b4\ub5bb\uac8c \uc6b0\ub9ac\uac00 \uc6d0\ud558\ub4ef \uc911\ubcf5\uc790\ub8cc\ub97c \uc81c\uc678\ud55c \uc9c1\uacc4 \uc790\ub8cc\ub9cc\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub098?<\/p>\n<p>\ubb38\uc81c\uac00 \ub418\ub294 C \ub97c \ub193\uace0 \ubd05\uc2dc\ub2e4.<br \/>\n\uc704\uc758 \uacb0\uacfc\uc911 A.NO \uac00 10 \uc778 9\uac1c ROW\ub97c \uc790\uc138\ud788 \uc0b4\ud3b4\ubd05\uc2dc\ub2e4.<\/p>\n<p>NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN<br \/>\n&#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;-<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/p>\n<p>\ucd5c\ucd08 \uc21c\uc804\uac1c \uc790\ub8cc\ub3c4 \ub193\uace0 \ud568\uaed8 \ube44\uad50\ud574 \ubd05\ub2c8\ub2e4<\/p>\n<p>LEVELNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LVNO\u00a0\u00a0 PA QNTY<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212; &#8212; &#8212;&#8211;<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 B\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 C\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 E\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 F\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 I\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 D\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 H\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 J\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 C\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 E\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n&#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 I\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n&#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 K\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/p>\n<p>\ucd5c\ucd08 \uc21c\uc804\uac1c \uc790\ub8cc\uc758 10\ubc88\uc9f8\uc5d0 \uc704\uce58\ud558\ub294<br \/>\nLEVELNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LVNO\u00a0\u00a0 PA QNTY<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212; &#8212; &#8212;&#8211;<br \/>\n&#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 C\u00a0\u00a0\u00a0\u00a0\u00a0 6<\/p>\n<p>\uc774 \uc790\ub8cc\uc640 \uad00\uacc4\uac00 \uc788\ub294 \uacb0\uacfc\ub97c \uc0b4\ud53c\uace0 \uc788\ub294 \uc911\uc785\ub2c8\ub2e4.<br \/>\n\uc774\uc790\ub8cc\uc758 \uc9c1\uacc4 \uc0c1\uc704 PART \ub294 \uc21c\uc804\uac1c \uc790\ub8cc\ub97c \ubcf4\uba74 \ud55c\ub208\uc5d0 \uc54c\uc218 \uc788\ub4ef\uc774<br \/>\nJ,D,B \uc785\ub2c8\ub2e4.<br \/>\nJ,D,B \uc5d0 \ud574\ub2f9\ud558\ub294 \uac74\uc744 \uc704\uc758 9\uac1c ROW\uc5d0\uc11c \uc9d1\uc911\uc801\uc73c\ub85c \uc0b4\ud3b4\ubcf4\uc138\uc694.<br \/>\n\ubb54\uac00 \ub2e4\ub978 \uc790\ub8cc\uc640 \ucc28\uc774\uac00 \uc788\uc744 \uac81\ub2c8\ub2e4.<br \/>\n\ubb50\uac00 \ub2e4\ub97c\uae4c\uc694?.<br \/>\n\uc138 \uc790\ub8cc\uac00 \ubaa8\ub450 B.LEN \uc774 \uac19\uc740 \uc790\ub8cc\ub4e4\uc911\uc5d0\uc11c B.NO \uac00 \uac00\uc7a5 \ud070 \uc790\ub8cc\ub4e4\uc785\ub2c8\ub2e4.<br \/>\n\uc989 J\uc758 \uacbd\uc6b0\ub294 B.LEN \uc774 3\uc778<br \/>\nNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN<br \/>\n&#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;-<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/p>\n<p>\uc774 \ub2e4\uc12f\uac74\uc911\uc5d0 B.NO \uac00 9\ub85c \uac00\uc7a5 \uac12\uc774 \ud07d\ub2c8\ub2e4.<br \/>\nD \uc640 B\ub3c4 \ub9c8\ucc2c\uac00\uc9c0 \uc785\ub2c8\ub2e4.<\/p>\n<p><\/span><span style=\"font-size: small;\"><span style=\"color: mediumslateblue;\"><strong>\ub2e8\uacc43.<br \/>\n<\/strong><\/span>\u00a0\u00a0 \uc5ec\uae30\uae4c\uc9c0 \uc0dd\uac01\uc744 \uc815\ub9ac \ud588\ub2e4\uba74 \uc774\uc81c \ub0a8\uc740\uac74 \uac19\uc740 A.NO \ub97c \uac00\uc9c4 ROW\ub4e4\uc744 \ub300\uc0c1\uc73c\ub85c<br \/>\n\ub3d9\uc77c B.LEN \uc744 \uac00\uc9c4\uac83\ub07c\ub9ac GROUP \uc744 \uc9c0\uc5b4 B.NO \uac00 \ucd5c\ub300\uac12\uc5d0 \ud574\ub2f9\ud558\ub294 \uc790\ub8cc\ub9cc \uac78\ub7ec\ub0b4\uba74 \ub429\ub2c8\ub2e4.<br \/>\n\uac78\ub7ec\ub0b8 \uacb0\uacfc\uac00 \uc6b0\ub9ac\uac00 \uc6d0\ud558\ub358 \ud2b9\uc815\ubd80\ud488\uc744 \uae30\uc900\uc73c\ub85c \uc9c1\uacc4\uc0c1\uc704 \ubd80\ud488\uc774 \ub418\ub294\uac81\ub2c8\ub2e4.<\/p>\n<p>\ub2e8\uacc42\uc758 QUERY \ub97c \uc57d\uac04 \uc218\uc815\ud574 \ubd05\uc2dc\ub2e4.<br \/>\n\ubc14\ub00c\ub294 \ubd80\ubd84\uc740 GROUP BY \ub97c \uc704\ud558\uc5ec SELECT \uc808\uc774 \uc218\uc815\ub418\uace0 GROUP BY \uac00 \ucd94\uac00\ub418\ub294 \uc218\uc900\uc785\ub2c8\ub2e4.<\/p>\n<p>SQL<\/p>\n<p><\/span><span style=\"font-size: small;\"><span style=\"color: mediumblue;\">SELECT A.NO,A.PARTNO,A.LEN,B.LEN,<br \/>\nMAX(LTRIM(TO_CHAR(B.NO,&#8217;0000000&#8242;))||LTRIM(TO_CHAR(B.QNTY,&#8217;000000000&#8242;))||B.PARTNO) TEM<br \/>\nFROM (SELECT NO,PARTNO,PART,<br \/>\nLEN<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,PART,<br \/>\nLENGTHB(PART) -1 LEN<br \/>\nFROM\u00a0 (<br \/>\nSELECT LPAD(PARTNO, DECODE(LEVEL,1,1,LEVEL),&#8217; &#8216;) AS PART,PARTNO<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) A,<br \/>\n(SELECT NO,PARTNO,PART,<br \/>\nLEN,QNTY<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,PART,<br \/>\nLENGTHB(PART) -1 LEN,QNTY<br \/>\nFROM\u00a0 (<br \/>\nSELECT LPAD(PARTNO, DECODE(LEVEL,1,1,LEVEL),&#8217; &#8216;) AS PART,PARTNO,QNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) B<br \/>\nWHERE B.NO(+)\u00a0 &lt; A.NO<br \/>\nAND\u00a0\u00a0 B.LEN(+) &lt; A.LEN<br \/>\nGROUP BY A.NO,A.PARTNO,A.LEN,B.LEN;<br \/>\n<\/span><br \/>\n\uacb0\uacfc<br \/>\nNO\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PA LEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TEM<br \/>\n&#8212;&#8212;&#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<br \/>\n2 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<br \/>\n3 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n4 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000003000000003C<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000003000000003C<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n6 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000003000000003C<br \/>\n7 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n8 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n9 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n10 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 0000009000000004J<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 0000009000000004J<br \/>\n11 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 0000010000000006C<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 0000009000000004J<br \/>\n12 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 0000010000000006C<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 0000009000000004J<br \/>\n13 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 0000010000000006C<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 0000002000000002B<br \/>\n14 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 0000007000000004D<br \/>\n31 rows selected.<\/p>\n<p>66\uac74\uc758 \uc790\ub8cc\uac00 31\uac74\uc73c\ub85c \uc904\uc5b4\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<br \/>\n\uac01 NO \ubcc4\ub85c \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/p>\n<p>\ub9c8\uc9c0\ub9c9 TEM \uceec\ub7fc\uc740 B.NO \uac00 MAX \uc778\uac74\uc744 \ucc3e\uc744\ub54c<br \/>\n\ud574\ub2f9 \ub808\ucf54\ub4dc\uc758 \uc218\ub7c9\uacfc \uc0c1\uc704 PART \ub97c \ud568\uaed8 \ubb36\uc5b4\uc11c \ubd99\uc5ec\ub193\uc740\uac81\ub2c8\ub2e4.<br \/>\n\ub098\uc911\uc5d0 \uc218\ub7c9\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574 \uc800\uc9c0\ub978 \uc9d3\uc785\ub2c8\ub2e4.<br \/>\n<strong><span style=\"color: mediumslateblue;\">\ub2e8\uacc44.<\/span><\/strong><br \/>\n\uc774\uc81c \ub0a8\uc740 \uc77c\uc740 \ucd5c\ucd08 \uc21c\uc804\uac1c \uc790\ub8cc\uc640 \uc870\uc778\uc744 \uac70\ub294 \uc77c\uc785\ub2c8\ub2e4.<br \/>\n\uc774\ub54c \uc870\uc778\uc870\uac74\uc740 NO \uac00 \ub3d9\uc77c\ud55c EQUI-JOIN \uc785\ub2c8\ub2e4.<\/p>\n<p>\uc21c\uc804\uac1c SQL \ubc0f \uacb0\uacfc<\/p>\n<p>SQL<br \/>\nSELECT ROWNUM NO,<br \/>\nLPAD(LEVEL, DECODE(LEVEL,1,1,(LEVEL*2)-1),&#8217;.&#8217;) AS LEVELNO,<br \/>\nLEVEL AS LVNO,<br \/>\nPARTNO,<br \/>\nQNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<\/p>\n<p>\uacb0\uacfc<br \/>\nNO\u00a0\u00a0\u00a0 LEVELNO\u00a0\u00a0\u00a0\u00a0 LVNO\u00a0\u00a0 PA QNTY<br \/>\n&#8212;&#8211; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212; &#8212; &#8212;&#8212;-<br \/>\n1 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n3 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n4 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n5 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n6 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n7 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n8 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n9 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n10 &#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\n11 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n12 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<br \/>\n13 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5<br \/>\n14 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<br \/>\n14 rows selected.<\/p>\n<p><strong><span style=\"color: mediumslateblue;\">\ucd5c\uc885 SQL \ubc0f \uacb0\uacfc<br \/>\n<\/span><\/strong><br \/>\nSQL<\/p>\n<p><span style=\"color: blue;\">SELECT B.NO,<br \/>\nB.LEVELNO,<br \/>\nB.LVNO,<br \/>\nB.PARTNO,<br \/>\nB.QNTY,<br \/>\nB.QNTY*EXP(SUM(LN(NVL(TO_NUMBER(SUBSTRB(A.TEM,8,9)),1))))<br \/>\nFROM\u00a0 (SELECT A.NO,A.PARTNO,A.LEN,A.PARTNO,B.LEN,<br \/>\nMAX(LTRIM(TO_CHAR(B.NO,&#8217;0000000&#8242;))||LTRIM(TO_CHAR(B.QNTY,&#8217;000000000&#8242;))||B.PARTNO) TEM<br \/>\nFROM (SELECT NO,PARTNO,<br \/>\nLEN<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,<br \/>\nLEV LEN<br \/>\nFROM\u00a0 (<br \/>\nSELECT LEVEL LEV,PARTNO<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) A,<br \/>\n(SELECT NO,PARTNO,<br \/>\nLEN,QNTY<br \/>\nFROM (SELECT ROWNUM NO,PARTNO,<br \/>\nLEV LEN,QNTY<br \/>\nFROM\u00a0 (<br \/>\nSELECT LEVEL LEV,PARTNO,QNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n)<br \/>\n)<br \/>\n) B<br \/>\nWHERE B.NO(+)\u00a0 &lt; A.NO<br \/>\nAND\u00a0\u00a0 B.LEN(+) &lt; A.LEN<br \/>\nGROUP BY A.NO,A.PARTNO,A.LEN,A.PARTNO,B.LEN<br \/>\n) A,<br \/>\n(<br \/>\nSELECT ROWNUM NO,<br \/>\nLPAD(LEVEL, DECODE(LEVEL,1,1,(LEVEL*2)-1),&#8217;.&#8217;) AS LEVELNO,<br \/>\nLEVEL AS LVNO,<br \/>\nPARTNO,<br \/>\nQNTY<br \/>\nFROM BOM<br \/>\nSTART WITH PARTNOM=&#8217;X&#8217;<br \/>\nCONNECT BY PRIOR PARTNO=PARTNOM<br \/>\n) B<br \/>\nWHERE B.NO=A.NO<br \/>\nGROUP BY B.NO,<br \/>\nB.LEVELNO,<br \/>\nB.LVNO,<br \/>\nB.PARTNO,<br \/>\nB.QNTY\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p>\uacb0\uacfc<\/p>\n<p>NO\u00a0\u00a0\u00a0 LEVELNO\u00a0\u00a0\u00a0 LVNO\u00a0\u00a0 PA QNTY\u00a0\u00a0 B.QNTY*EXP<br \/>\n&#8212;&#8211; &#8212;&#8212;&#8212;- &#8212;&#8212; &#8212; &#8212;&#8212; &#8212;&#8212;&#8212;-<br \/>\n1 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<br \/>\n2 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 B\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<br \/>\n3 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<br \/>\n4 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 18<br \/>\n5 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24<br \/>\n6 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30<br \/>\n7 ..2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 D\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8<br \/>\n8 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 H\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16<br \/>\n9 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 J\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32<br \/>\n10 &#8230;&#8230;4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 C\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 192<br \/>\n11 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 E\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 576<br \/>\n12 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 F\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 768<br \/>\n13 &#8230;&#8230;..5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 I\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 960<br \/>\n14 &#8230;.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3 K\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24<br \/>\n14 rows selected<\/p>\n<p>\ucd5c\uc885\uacb0\uacfc\uc758 SELECT\u00a0\uc911<\/p>\n<p>B.QNTY*EXP(SUM(LN(NVL(TO_NUMBER(SUBSTRB(A.TEM,8,9)),1))))<\/p>\n<p>\uc124\uba85<\/span><\/p>\n<p><span style=\"font-size: small;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc774\ubd80\ubd84\uc740 \uc790\uc2e0\uc758PART \uc218\ub7c9\uacfc \uc790\uc2e0\uc758 \uc0c1\uc704PART \uc218\ub7c9\ub4e4\uac04\uc758 \uacf1\uc148\uc744 \ud558\uae30 \uc704\ud55c \ubd80\ubd84\uc785\ub2c8\ub2e4.<br \/>\n\uc790\uc2e0\uc758 \uc0c1\uc704\uc5d0 \ud574\ub2f9\ud558\ub294 PART \ub9cc \ucc3e\uc544\ub193\uc740 \uc0c1\ud0dc\uc774\ubbc0\ub85c \ucd5c\uc885\uc801\uc73c\ub85c \uc790\uc2e0\uc758 \uc218\ub7c9\uc744 \uacf1\ud574\uc90d\ub2c8\ub2e4.<br \/>\n<\/span><\/p>\n<p><span style=\"font-size: small;\">\ud38c)\u00a0<a href=\"http:\/\/www.dbguide.net\/dbqna.db?cmd=view&amp;boardUid=144073&amp;boardConfigUid=31&amp;boardStep=0&amp;categoryUid=205&amp;boardIdx=406\">http:\/\/www.dbguide.net\/dbqna.db?cmd=view&amp;boardUid=144073&amp;boardConfigUid=31&amp;boardStep=0&amp;categoryUid=205&amp;boardIdx=406<\/a><\/span><\/p>\n<div class=\"container_postbtn #post_button_group\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"trackbackListBlock_$article.articleNo\"><\/div>\n<div id=\"entry16498271Comment\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc758 &#8216;connect by start with&#8217; \uc5d0\uc11c \ubcf4\uae30 \uc5b4\ub824\uc6b4 \uc911\ubcf5\uac00\uc9c0\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\uc758 \ub204\uc801\ud658\uc0b0\ub7c9\uc744 \uad6c\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \/* 1. BOM\ud14c\uc774\ube14 *\/ CREATE TABLE BOM ( PartNo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(2),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* PartNo *\/ PartNoM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(10),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* \ubd80\ubaa8PARTNO *\/ Qnty\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(10)\u00a0\u00a0 NOT NULL,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/* \ub2e8\uc704\ub2f9\uc18c\uc694\ub7c9 *\/ CONSTRAINT pk_g_BOM PRIMARY KEY (PartNo, PartNoM)); \/* 2. DATA *\/ INSERT INTO BOM VALUES [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-820","post","type-post","status-publish","format-standard","hentry","category-about-oracle"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=820"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/820\/revisions"}],"predecessor-version":[{"id":821,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/820\/revisions\/821"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}