dbms:oracle:10g:devel

차이

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

차이 보기로 링크

--- 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 =====
-| [[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 =====
-| [[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
@@ 줄 19: / 줄 26: @@
 ===== 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 - 오라클정규표현식 ]]
-  - [[dbms:oracle:devel:hierarchical | HIERARCHICAL QUERY (계층쿼리) ]]
+  - GROUPING SETS
-  - [[dbms:oracle:devel:with | WITH 절 ]]
+  - Flashback Query
-  - [[dbms:oracle:devel:analytic | Analytic Function - 분석함수 ]]
+  - Version Query
-    - [[dbms:oracle:devel:rank | 순위 매기는 RANK 함수 ]]
+  - Transaction Query
-  - [[dbms:oracle:devel:groupset | GROUPING SETS ]]
-  - [[dbms:oracle:devel:flashbackquery | Flashback Query ]]
-  - [[dbms:oracle:devel:versionquery | Version Query ]]
+===== Data Migration =====
-  - [[dbms:oracle:devel:transactionquery | Transaction Query ]]
+  - [[ 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 ]]

dbms/oracle/10g/devel.1282660760.txt.gz · 마지막으로 수정됨: 2010/08/24 23:39 저자 starlits