목차

Oracle Development

SQL

  1. SQL/92
  2. SQL/99

PL/SQL

  1. Function
  2. Procedure
  3. Package
  4. Trigger
  5. Exception

기본함수

  1. Single Row Functions
  2. Aggregate Functions
  3. Grouping Rows

날짜함수 / 시간함수

서브쿼리(SubQuery)

Oracle Advanced Queries

  1. Set Operators
  2. TRANSLATE() Function
  3. DECODE() Function
  4. CASE
  5. HIERARCHICAL QUERY (계층쿼리)
  6. WITH 절
  7. GROUP BY Clauses
  8. ROLLUP Clauses
  9. Analytic Function - 분석함수
    1. Inverse Percentile Functions
    2. Window Functions
    3. Reporting Functions
    4. LAG() and LEAD() Functions
    5. FIRST and LAST Functions
    6. Linear Regression Functions
    7. Hypothetical Rank and Distribution Functions
  10. MODEL Clauses
  11. GROUPING SETS
  12. Flashback Query
  13. Version Query
  14. Transaction Query

Data Migration