문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 | ||
dbms:oracle:10g:devel [2010/08/24 23:20] 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: | + | |
+ | - Function | ||
+ | - Procedure | ||
+ | - Package | ||
+ | - Trigger | ||
+ | - Exception | ||
+ | ===== 기본함수 ===== | ||
+ | - Single Row Functions | ||
+ | - Aggregate Functions | ||
+ | - Grouping Rows | ||
- | ===== Oracle Advanced Queries | + | ===== 날짜함수 / 시간함수 |
- | + | ||
- | - [[dbms: | + | |
- [[dbms: | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | - [[dbms: | ||
- | |||
- | ===== 개인적 취향 ===== | ||
- | - [[dbms: | ||
- | |||
- | ===== 정리중인 문서 ===== | ||
- | - [[dbms: | ||
+ | ===== 서브쿼리(SubQuery) ===== | ||
+ | ===== 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: | ||
+ | - GROUPING SETS | ||
+ | - Flashback Query | ||
+ | - Version Query | ||
+ | - Transaction Query | ||
+ | ===== Data Migration ===== | ||
+ | - [[ https:// | ||
+ | - [[ http:// | ||
+ | - [[ https:// | ||
+ | ===== Oracle Search ===== | ||
+ | - [[ https:// | ||
+ | - [[ http:// |