728x90

목록분류 전체보기 (659)

DBILITY

oracle flash back query

SELECT * FROM TABLE_NAME AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '10' MINUTE)
database/oracle 2016. 9. 7. 19:54
weblogic 12c developer사용시 eclipse,intellij에서 연동할때 서버속성에 추가

weblogic 12c developer사용시 eclipse, intellij에서 연동할때 서버속성에 추가 #서버용 클래스패스 CLASSPATH %CLASSPATH%;C:\Dev64\maven\repository\com\ibm\as400\access\AS400JDBCDriver\1.0\AS400JDBCDriver-1.0.jar #console 한글깨짐방지 EXTRA_JAVA_PROPERTIES -Dfile.encoding=UTF8 -Dfile.client.encoding=UTF8 #메모리설정 USER_MEM_ARGS -XX:PermSize=128m -XX:MaxPermSize=256m -Xms1024m -Xmx1024m -XX:NewRatio=2 -XX:+UseParallelGC -XX:-UseConcM..
eclipse 2016. 9. 7. 19:52
Oracle Gateway Master Note (Doc ID 1083703.1)

Master Note for Oracle Gateway Products 1. Concepts and Availability Oracle Gateway products are based on Heterogeneous Services and allow access to non-Oracle databases from Oracle products.Heterogeneous Services provides the generic technology for connecting to non-Oracle systems. As an integrated component of the database, Heterogeneous Services can exploit features of the database, such as t..
database/oracle 2016. 9. 7. 19:42
oracle unpivot string comma separate to row

오라클에서 테스트되었습니다. UI에서 comma로 연결된 argument를 입력받아 분리 후 행으로 변환하여 조건으로 공급하는 SQL에 응용하였던 적이 있습니다. WITH T1 ( CN ) AS ( SELECT ','||TRIM('A1,A2,A3,A4,') FROM DUAL ) SELECT SUBSTR(T1.CN,INSTR(T1.CN,',',1,LEVEL)+1,INSTR(T1.CN,',',1,LEVEL+1)-INSTR(T1.CN,',',1,LEVEL)-1)CN FROM T1 CONNECT BY LEVEL
database/sql 2016. 9. 7. 19:31
DB2 for i SQL Reference 7.1

IBM공식사이트에서 다운로드하였습니다.
database/db2 for iseries 2016. 9. 7. 19:19
Prev 1 ··· 128 129 130 131 132 Next
728x90