https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=%EC%98%A4%EB%9D%BC%ED%81%B4_%EC%B4%88%EB%B3%B4%EC%9E%90_%ED%95%99%EC%8A%B5%EA%B3%BC%EC%A0%95 2026-05-08T19:29:41Z 이 문서의 편집 역사 MediaWiki 1.39.10 https://dbstudy.co.kr/w/index.php?title=%EC%98%A4%EB%9D%BC%ED%81%B4_%EC%B4%88%EB%B3%B4%EC%9E%90_%ED%95%99%EC%8A%B5%EA%B3%BC%EC%A0%95&diff=1212&oldid=prev 2025-08-12T14:35:43Z

<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년 8월 12일 (화) 23:35 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">1번째 줄:</td> <td colspan="2" class="diff-lineno">1번째 줄:</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;">__notoc__</del></div></td><td colspan="2" class="diff-side-added"></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;">https://dbstudy.co.kr/w/resources/assets/dbstudy_iconx1.png </del></div></td><td colspan="2" class="diff-side-added"></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;">= Welcome To DB STUDY - {{CURRENTYEAR}}.{{CURRENTMONTHNAME}}.{{CURRENTDAY}}({{CURRENTDAYNAME}}) =</del></div></td><td colspan="2" class="diff-side-added"></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;">* {{SERVER}}</del></div></td><td colspan="2" class="diff-side-added"></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;">* 게시글 총 : {{NUMBEROFPAGES}} 건 , 사용자 : {{NUMBEROFUSERS}} 명 , </del></div></td><td colspan="2" class="diff-side-added"></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;p sizes="(max-width: 600px) 480px,800px"></del></div></td><td colspan="2" class="diff-side-added"></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;">https://dbstudy.co.kr/w/images/dbstudy_logo.jpg</del></div></td><td colspan="2" class="diff-side-added"></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;/p></del></div></td><td colspan="2" class="diff-side-added"></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;">{{틀:타이틀 라운드</del></div></td><td colspan="2" class="diff-side-added"></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;">|제목=[[:Category:oracle|오라클]]: {{PAGESINCATEGORY: oracle}} 건 ,  [[:Category:postgresql|PostgreSql]] : {{PAGESINCATEGORY: postgresql}} 건 ,  [[:Category:mysql|MySQL]]: {{PAGESINCATEGORY: mysql}} 건,  [[:Category:linux|LINUX]]: {{PAGESINCATEGORY: linux}} 건</del></div></td><td colspan="2" class="diff-side-added"></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;">|아이콘=emoji_objects</del></div></td><td colspan="2" class="diff-side-added"></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;">}}</del></div></td><td colspan="2" class="diff-side-added"></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;"></del></div></td><td colspan="2" class="diff-side-added"></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;">= ORACLE =</del></div></td><td colspan="2" class="diff-side-added"></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;"></del></div></td><td colspan="2" class="diff-side-added"></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>== [[ORACLE SQL 30일 학습|오라클 SQL 30일 학습]]==</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>== [[ORACLE SQL 30일 학습|오라클 SQL 30일 학습]]==</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># [[SQL 기본]]  </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># [[SQL 기본]]  </div></td></tr> </table>

Oracle https://dbstudy.co.kr/w/index.php?title=%EC%98%A4%EB%9D%BC%ED%81%B4_%EC%B4%88%EB%B3%B4%EC%9E%90_%ED%95%99%EC%8A%B5%EA%B3%BC%EC%A0%95&diff=1211&oldid=prev 2025-08-12T14:35:27Z

<p>새 문서: __notoc__ https://dbstudy.co.kr/w/resources/assets/dbstudy_iconx1.png = Welcome To DB STUDY - {{CURRENTYEAR}}.{{CURRENTMONTHNAME}}.{{CURRENTDAY}}({{CURRENTDAYNAME}}) = * {{SERVER}} * 게시글 총 : {{NUMBEROFPAGES}} 건 , 사용자 : {{NUMBEROFUSERS}} 명 , &lt;p sizes=&quot;(max-width: 600px) 480px,800px&quot;&gt; https://dbstudy.co.kr/w/images/dbstudy_logo.jpg &lt;/p&gt; {{틀:타이틀 라운드 |제목=<a href="/w/%EB%B6%84%EB%A5%98:Oracle" title="분류:Oracle">오라클</a>: {{PAGESINCATEGORY: oracle}} 건 , :Category:postgresql|Po...</p> <p><b>새 문서</b></p><div>__notoc__<br /> https://dbstudy.co.kr/w/resources/assets/dbstudy_iconx1.png <br /> = Welcome To DB STUDY - {{CURRENTYEAR}}.{{CURRENTMONTHNAME}}.{{CURRENTDAY}}({{CURRENTDAYNAME}}) =<br /> * {{SERVER}}<br /> * 게시글 총 : {{NUMBEROFPAGES}} 건 , 사용자 : {{NUMBEROFUSERS}} 명 , <br /> &lt;p sizes=&quot;(max-width: 600px) 480px,800px&quot;&gt;<br /> https://dbstudy.co.kr/w/images/dbstudy_logo.jpg<br /> &lt;/p&gt;<br /> {{틀:타이틀 라운드<br /> |제목=[[:Category:oracle|오라클]]: {{PAGESINCATEGORY: oracle}} 건 , [[:Category:postgresql|PostgreSql]] : {{PAGESINCATEGORY: postgresql}} 건 , [[:Category:mysql|MySQL]]: {{PAGESINCATEGORY: mysql}} 건, [[:Category:linux|LINUX]]: {{PAGESINCATEGORY: linux}} 건<br /> |아이콘=emoji_objects<br /> }}<br /> <br /> = ORACLE =<br /> <br /> == [[ORACLE SQL 30일 학습|오라클 SQL 30일 학습]]==<br /> # [[SQL 기본]] <br /> ## [[데이터 베이스 용어 설명]] <br /> ## [[데이터 베이스 용어 설명#현업에서 사용하는 업무 용어|현업에서 사용하는 업무용어]]<br /> ## [[데이터 베이스 용어 설명#SQL 종류|SQL 종류]]<br /> ## [[테이블 컬럼 데이터 유형|컬럼 데이터 유형]]<br /> # [[SQL 실행]]<br /> ## [[테이블 생성 과 데이터입력 ]] <br /> ## [[SELECT 구문|SELECT 기본 구문 작성 순서]] <br /> ## [[GROUP BY 절]] <br /> ## [[SQL 조인]] <br /> ## [[WITH 절]] <br /> ## [[INSERT 구문]] <br /> ## [[UPDATE 구문]] <br /> ## [[DELETE 구문]]<br /> ## [[MERGE 구문]] <br /> ## [[CREATE TABLE 구문]]<br /> ## [[ALTER TABLE 구문]]<br /> ## [[DROP TABLE 구문]]<br /> ## [[TRUNCATE TABLE 구문]]<br /> # SQL 활용<br /> ## [[오라클SQL 과 안시SQL]] <br /> ## [[SQL 실행원리 와 과정 ]]<br /> ## [[최적의 SQL 작성법]] <br /> ## [[스칼라 인라인뷰 서브쿼리|서브쿼리(스칼라/인라인뷰/서브쿼리)]]<br /> ## [[오라클 내부함수]]<br /> ## [[원도우 함수|윈도우 함수(분석 함수)]]<br /> ## [[집계함수 (aggregate function)]]<br /> ## [[그룹 함수]]<br /> ## [[인덱스]] <br /> ## [[CONNECT BY 절]] <br /> ## [[LATERAL]]<br /> # [[SQL 핵심 개념 이해]]<br /> ## [[테이블 조인 방식]]<br /> ### [[NL 조인]]<br /> ### [[HASH 조인]]<br /> ### [[MERGE 조인]]<br /> # [[PL/SQL 기초|&#039;&#039;&#039;PL/SQL 기초&#039;&#039;&#039;]] <br /> ## [[함수]] <br /> ## [[프로시져]] <br /> ## [[패키지]] <br /> ## [[트리거]] <br /> # SQL 고급<br /> ## [[정규표현식(regular expression)]]<br /> ## [[전체 텍스트 검색 match]]<br /> ## [[테이블 샘플링 (Table Sampling)]]<br /> ## [[임시 테이블 (Temporary Tables)]]<br /> ## [[동적 SQL (Dynamic SQL)]]<br /> ----</div>

Oracle