https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=%EC%B9%B4%ED%85%8C%EC%8B%9C%EC%95%88_%EC%A1%B0%EC%9D%B8 2026-05-08T20:48:13Z 이 문서의 편집 역사 MediaWiki 1.39.10 https://dbstudy.co.kr/w/index.php?title=%EC%B9%B4%ED%85%8C%EC%8B%9C%EC%95%88_%EC%A1%B0%EC%9D%B8&diff=242&oldid=prev 2025-04-28T05:59:14Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 4월 28일 (월) 14:59 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l12">12번째 줄:</td> <td colspan="2" class="diff-lineno">12번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       CONNECT BY LEVEL &lt;= 10) B -- 10개 row 생성</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>       CONNECT BY LEVEL &lt;= 10) B -- 10개 row 생성</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>---- join 조건이 없다  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>---- join 조건이 없다  </div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;source <del style="font-weight: bold; text-decoration: none;">lang=sql</del>&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;<ins style="font-weight: bold; text-decoration: none;">/</ins>source&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 10 x 10 = 100 rows가 출력 된다.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 10 x 10 = 100 rows가 출력 된다.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.)</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">&lt;/source&gt;</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:oracle]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:oracle]]</div></td></tr> </table>

Dbstudy https://dbstudy.co.kr/w/index.php?title=%EC%B9%B4%ED%85%8C%EC%8B%9C%EC%95%88_%EC%A1%B0%EC%9D%B8&diff=241&oldid=prev 2025-04-28T05:58:51Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 4월 28일 (월) 14:58 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l15">15번째 줄:</td> <td colspan="2" class="diff-lineno">15번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 10 x 10 = 100 rows가 출력 된다.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 10 x 10 = 100 rows가 출력 된다.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.)</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/source></ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:oracle]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[category:oracle]]</div></td></tr> </table>

Dbstudy https://dbstudy.co.kr/w/index.php?title=%EC%B9%B4%ED%85%8C%EC%8B%9C%EC%95%88_%EC%A1%B0%EC%9D%B8&diff=240&oldid=prev 2025-04-28T05:58:37Z

<p>새 문서: == 카테시안 조인 == * 예제 &lt;source lang=sql&gt; SELECT * FROM (SELECT LEVEL COL FROM DUAL CONNECT BY LEVEL &lt;= 10) A -- 10개 row 생성 , (SELECT LEVEL COL FROM DUAL CONNECT BY LEVEL &lt;= 10) B -- 10개 row 생성 ---- join 조건이 없다 &lt;source lang=sql&gt; * 10 x 10 = 100 rows가 출력 된다. * 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.) <a href="/w/%EB%B6%84%EB%A5%98:Oracle" title="분류:Oracle">category:oracle</a></p> <p><b>새 문서</b></p><div>== 카테시안 조인 ==<br /> <br /> * 예제<br /> <br /> &lt;source lang=sql&gt;<br /> SELECT *<br /> FROM (SELECT LEVEL COL <br /> FROM DUAL<br /> CONNECT BY LEVEL &lt;= 10) A -- 10개 row 생성<br /> , (SELECT LEVEL COL <br /> FROM DUAL<br /> CONNECT BY LEVEL &lt;= 10) B -- 10개 row 생성<br /> ---- join 조건이 없다 <br /> &lt;source lang=sql&gt;<br /> * 10 x 10 = 100 rows가 출력 된다.<br /> * 이를 카테시언 프로덕트 조인이라 한다.(보통 join 조건이 빠졌을 경우 존재한다.)<br /> <br /> [[category:oracle]]</div>

Dbstudy