728x90

목록전체 글 (663)

DBILITY

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
Oracle XA설정시 버전별 참고사항

Oracle 10.2.0.3 and lower NOTE: this tip was written with Oracle DBMS version 10.2.0.2.0 How can you know if your Oracle server is correctly configured for XA? The simplest and usually the most effective way is the following: logon to SQLPlus (or use another tool if you like); make sure to use the user/password that you are using for your application execute the query: select * from SYS.DBA_PEND..
database/oracle 2016. 9. 7. 13:13
Prev 1 ··· 129 130 131 132 133 Next
728x90