양쪽 이전 판이전 판다음 판 | 이전 판 |
dbms:oracle:10g:devel [2015/06/08 08:44] – [PL/SQL] starlits | dbms:oracle:10g:devel [2025/10/03 22:30] (현재) – 바깥 편집 127.0.0.1 |
---|
- 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 Functions ]] | - [[dbms:oracle:devel:rank | RANK Functions ]] |
- Inverse Percentile Functions | - Inverse Percentile 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 ]] |