목차

Oracle Development

SQL

  1. SQL*PLUS
  2. 오라클 조인(Join)의 방법과 형태
  3. SQL/92
  4. SQL/99

PL/SQL

  1. PL/SQL 기초
  2. Function
  3. Procedure
  4. Package
  5. Trigger
  6. Exception

기본함수

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

날짜함수 / 시간함수

  1. 날짜 함수

서브쿼리(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. RANK Functions
    2. Inverse Percentile Functions
    3. Window Functions
    4. Reporting Functions
    5. LAG() and LEAD() Functions
    6. FIRST and LAST Functions
    7. Linear Regression Functions
    8. Hypothetical Rank and Distribution Functions
  10. MODEL Clauses
  11. Oracle Regular Expression - 오라클정규표현식
  12. GROUPING SETS
  13. Flashback Query
  14. Version Query
  15. Transaction Query

Data Migration

  1. SQL Developer: Migrating Third-Party Databases
  2. Migrating a Microsoft SQL Server Database to Oracle Database 11g
  3. Migration From SQL Server To Oracle Using SQL Developer
  1. ORACLE9I TEXT - KOREAN_MORPH_LEXER
  2. http://sphinxsearch.com/wiki/doku.php?id=sphinx_oracle_odbc