문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 | ||
dbms:oracle:10g:devel [2010/08/24 23:39] starlits |
dbms:oracle:10g:devel [2016/08/07 15:16] (현재) starlits [Oracle Search] |
||
---|---|---|---|
줄 3: | 줄 3: | ||
===== SQL ===== | ===== SQL ===== | ||
- | | [[dbms: | + | - [[dbms: |
+ | - [[dbms: | ||
+ | - SQL/92 | ||
+ | - SQL/99 | ||
===== PL/SQL ===== | ===== PL/SQL ===== | ||
- | | [[dbms: | + | - [[dbms: |
+ | - Function | ||
+ | - Procedure | ||
+ | - Package | ||
+ | - Trigger | ||
+ | - Exception | ||
===== 기본함수 ===== | ===== 기본함수 ===== | ||
- Single Row Functions | - Single Row Functions | ||
줄 19: | 줄 26: | ||
===== Oracle Advanced Queries ===== | ===== Oracle Advanced Queries ===== | ||
+ | - Set Operators | ||
+ | - TRANSLATE() Function | ||
+ | - DECODE() Function | ||
+ | - CASE | ||
+ | - HIERARCHICAL QUERY (계층쿼리) | ||
+ | - WITH 절 | ||
+ | - GROUP BY Clauses | ||
+ | - ROLLUP Clauses | ||
+ | - Analytic Function - 분석함수 | ||
+ | - [[dbms: | ||
+ | - Inverse Percentile Functions | ||
+ | - Window Functions | ||
+ | - Reporting Functions | ||
+ | - LAG() and LEAD() Functions | ||
+ | - FIRST and LAST Functions | ||
+ | - Linear Regression Functions | ||
+ | - Hypothetical Rank and Distribution Functions | ||
+ | - MODEL Clauses | ||
- [[dbms: | - [[dbms: | ||
- | - [[dbms: | + | - GROUPING SETS |
- | - [[dbms: | + | - Flashback Query |
- | - [[dbms: | + | - Version Query |
- | - [[dbms: | + | - Transaction Query |
- | - [[dbms: | + | |
- | - [[dbms: | + | |
- | - [[dbms: | + | ===== Data Migration ===== |
- | - [[dbms: | + | |
+ | - [[ https:// | ||
+ | - [[ http:// | ||
+ | - [[ https:// | ||
+ | ===== Oracle Search ===== | ||
+ | - [[ https:// | ||
+ | - [[ http:// |