사용자 도구

사이트 도구


dbms:oracle:10g:devel

차이

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

차이 보기로 링크

양쪽 이전 판 이전 판
다음 판
이전 판
dbms:oracle:10g:devel [2015/06/08 08:43]
starlits [SQL]
dbms:oracle:10g:devel [2016/08/07 15:16] (현재)
starlits [Oracle Search]
줄 9: 줄 9:
  
 ===== 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
줄 26: 줄 30:
   - 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
줄 41: 줄 45:
   - 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 ]]
dbms/oracle/10g/devel.1433720602.txt.gz · 마지막으로 수정됨: 2015/06/08 08:43 저자 starlits