728x90

목록전체 글 (666)

DBILITY

oracle insert into시 subquery factoring 사용 가능

INSERT INTO TARGET_T WITH X AS ( SELECT~ ) SELECT COLS~ FROM SOURCE_T,X
database/oracle 2016. 9. 7. 20:04
db2 for iseries에 dg4odbc로 연결하기

이거 보고 광고 한번 안 누른 이는 삼대가 재수가 없을지어다!ㅋㅋ Gateway용 서버에 win64_11gR2_gateways 및 db2 for iSeries용 odbc driver 설치 1.odbc datasource system dsn name = db2 driver iSeries Access ODBC Driver select only check,naming rule sql,object description type sql object comments 2.initdb2.ora ( initSID.ora ) # This is a sample agent init file that contains the HS parameters that are # needed for the Database Gateway f..
database/oracle 2016. 9. 7. 19:58
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
Prev 1 ··· 129 130 131 132 133 134 Next
728x90