차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

--- dbms:oracle:10g:devel [2010/08/24 23:20] – starlits
+++ dbms:oracle:10g:devel [2016/08/07 14:46] (현재) – [Oracle Search] starlits
@@ 줄 3: / 줄 3: @@
 ===== SQL =====
-| [[dbms:oracle:admin:oraclesqlplus|SQL*PLUS]] | [[dbms:oracle:sql:basic | SQL 기초]] | [[dbms:oracle:concept:sqloper | SQL 동작원리 ]] |
+  - [[dbms:oracle:admin:oraclesqlplus|SQL*PLUS]]
+  - [[dbms:oracle:concept:oraclejoin | 오라클 조인(Join)의 방법과 형태 ]]
+  - SQL/92
+  - SQL/99
-===== PL?SQL =====
+===== PL/SQL =====
-| [[dbms:oracle:devel:oracleplsql| PL/SQL 기초 ]] | [[dbms:oracle:devel:plsql:function | Function ]] | [[dbms:oracle:devel:plsql:procedure | Procedure ]] | [[dbms:oracle:devel:plsql:package | Package ]] | [[dbms:oracle:devel:plsql:trigger | Trigger ]] | [[dbms:oracle:devel:plsql:exception | Exception ]] |
+  - [[dbms:oracle:devel:oracleplsql| PL/SQL 기초 ]]
+  - Function
+  - Procedure
+  - Package
+  - Trigger
+  - Exception
+===== 기본함수 =====
+  - Single Row Functions
+  - Aggregate Functions
+  - Grouping Rows
-===== Oracle Advanced Queries =====
+===== 날짜함수 / 시간함수 =====
-  - [[dbms:oracle:devel:regexp | Oracle Regular Expression - 오라클정규표현식 ]]
   - [[dbms:oracle:devel:oracledatefunction | 날짜 함수 ]]
-  - [[dbms:oracle:concept:oraclejoin | 오라클 조인(Join)의 방법과 형태 ]]
-  - [[dbms:oracle:devel:rank | 순위 매기는 RANK 함수 ]]
-  - [[dbms:oracle:devel:hierarchical | HIERARCHICAL QUERY (계층쿼리) ]]
-  - [[dbms:oracle:devel:with | WITH 절 ]]
-  - [[dbms:oracle:devel:analytic | Analytic Function - 분석함수 ]]
-  - [[dbms:oracle:devel:groupset | GROUPING SETS ]]
-  - [[dbms:oracle:devel:flashbackquery | Flashback Query ]]
-  - [[dbms:oracle:devel:versionquery | Version Query ]]
-  - [[dbms:oracle:devel:transactionquery | Transaction Query ]]
-===== 개인적 취향 =====
-  - [[dbms:oracle:devel:functions | 애용하는 함수리스트 ]]
-===== 정리중인 문서 =====
-  - [[dbms:oracle:devel:group | 10g에서의 group 관련  ]]
+===== 서브쿼리(SubQuery) =====
+===== Oracle Advanced Queries =====
+  - Set Operators
+  - TRANSLATE() Function
+  - DECODE() Function
+  - CASE
+  - HIERARCHICAL QUERY (계층쿼리)
+  - WITH 절
+  - GROUP BY Clauses
+  - ROLLUP Clauses
+  - Analytic Function - 분석함수
+    - [[dbms:oracle:devel:rank | RANK Functions ]]
+    - 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:oracle:devel:regexp | Oracle Regular Expression - 오라클정규표현식 ]]
+  - GROUPING SETS
+  - Flashback Query
+  - Version Query
+  - Transaction Query
+===== Data Migration =====
+  - [[ https://docs.oracle.com/cd/E25259_01/appdev.31/e24285/migration.htm#RPTUG40000 | SQL Developer: Migrating Third-Party Databases ]]
+  - [[ http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLServerMigration/SQLServerMigration.htm#t5 | Migrating a Microsoft SQL Server Database to Oracle Database 11g ]]
+  - [[ https://taliphakanozturken.wordpress.com/2012/11/29/migration-from-sql-server-to-oracle-using-sql-developer/ | Migration From SQL Server To Oracle Using SQL Developer ]]
+===== Oracle Search =====
+  - [[ https://community.oracle.com/thread/473923?start=0&tstart=0 | ORACLE9I TEXT - KOREAN_MORPH_LEXER ]]
+  - [[ http://sphinxsearch.com/wiki/doku.php?id=sphinx_oracle_odbc ]]