DBILITY

SELECT * FROM TABLE_NAME AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '10' MINUTE)

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..

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..

오라클에서 테스트되었습니다. 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

IBM공식사이트에서 다운로드하였습니다.