양쪽 이전 판
이전 판
다음 판
|
이전 판
|
dbms:oracle:10g:devel [2010/08/24 23:42] starlits |
dbms:oracle:10g:devel [2016/08/07 15:16] starlits [Oracle Search] |
===== SQL ===== | ===== 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)의 방법과 형태 ]] | - [[dbms:oracle:concept:oraclejoin | 오라클 조인(Join)의 방법과 형태 ]] |
- SQL/92 | - SQL/92 |
| |
===== 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 | - Single Row Functions |
- DECODE() Function | - DECODE() Function |
- CASE | - CASE |
- [[dbms:oracle:devel:hierarchical | HIERARCHICAL QUERY (계층쿼리) ]] | - HIERARCHICAL QUERY (계층쿼리) |
- [[dbms:oracle:devel:with | WITH 절 ]] | - WITH 절 |
- GROUP BY Clauses | - GROUP BY Clauses |
- ROLLUP Clauses | - ROLLUP Clauses |
- [[dbms:oracle:devel:analytic | Analytic Function - 분석함수 ]] | - Analytic Function - 분석함수 |
- [[dbms:oracle:devel:rank | 순위 매기는 RANK 함수 ]] | - [[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 | - MODEL Clauses |
- [[dbms:oracle:devel:regexp | Oracle Regular Expression - 오라클정규표현식 ]] | - [[dbms:oracle:devel:regexp | Oracle Regular Expression - 오라클정규표현식 ]] |
- [[dbms:oracle:devel:groupset | GROUPING SETS ]] | - GROUPING SETS |
- [[dbms:oracle:devel:flashbackquery | Flashback Query ]] | - Flashback Query |
- [[dbms:oracle:devel:versionquery | Version Query ]] | - Version Query |
- [[dbms:oracle:devel:transactionquery | Transaction 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 ]] |