본문 바로가기

Prog.Lang. or Query

[작업 TIP] 쿼리 생성 스크립트 만들기 /* SQL 생성 스크립트 실행 파일 (execute_test) */ SET ECHO OFFSET NEWPAGE 0SET SPACE 0SET PAGESIZE 0SET FEEDBACK OFFSET HEADING OFFSET TRIMSPOOL ONSET FLUSH OFFSET VERIFY OFFSET TERM OFFSET HEAD OFF SPOOL 파일명.sql;@SQL생성스크립트 파라미터1 ...SPOOL OFF; ... /* SQL 생성 스크립트 */WITH T1 AS ( SELECT '&1' OW, '&2' TN FROM DUAL)SELECT NVL2(LAG(OWNER) OVER (ORDER BY COLUMN_ID),' , ','INSERT INTO '||TABLE_NAME||' ( '||CHR(10).. 더보기
[ODI] Calling Stored Procedures From Jython Scripts In ODI Applies to: Oracle Data Integrator - Version: 3.2.03 Information in this document applies to any platform.Goal Is it possible to call Database Stored Procedures from Jython? If so, what is the syntax? Solution Yes, it is possible to call Stored Procedures from Jython. Example with IN and OUT parameters The following is a sample in which the first parameter is sent to the procedure and the second.. 더보기
[SQL QUERY] SESSION MONITORING SQL SCRIPT SELECT /*+ PARALLEL(S,8) PARALLEL(Q,8) */ DISTINCT T.LOG_IO, T.PHY_IO ,T.CR_GET ,S.* FROM GV$SQL Q ,GV$SESSION S ,GV$TRANSACTION T WHERE S.SQL_ID = Q.SQL_ID AND S.INST_ID = Q.INST_ID AND SQL_TEXT LIKE '%INTO IDBADM.ODS_RT_TC_LCDR_DTL X%' AND SQL_TEXT NOT LIKE '%GV$%' AND S.SADDR = T.SES_ADDR(+) AND S.INST_ID = T.INST_ID(+) ORDER BY S.OWNERID DESC ,S.SID ; 더보기
[SQL QUERY] FIND ROWS THAT ARE NOT MAPPED IN OUTER JOIN TABLES WITH A AS ( SELECT 1 A, '매핑' MAPPED FROM DUAL UNION ALL SELECT 2 A, '매핑' MAPPED FROM DUAL UNION ALL SELECT 3 A, '미매핑' MAPPED FROM DUAL UNION ALL SELECT 4 A, '매핑' MAPPED FROM DUAL),B AS ( SELECT 1 A, '매핑' MAPPED FROM DUAL UNION ALL SELECT 2 A, '매핑' MAPPED FROM DUAL UNION ALL SELECT 4 A, '매핑' MAPPED FROM DUAL union all SELECT 5 A, '미매핑' MAPPED FROM DUAL ) SELECT * FROM A,B WHERE 1=1 AND A.A(+) = B.. 더보기
[ODI 11g] jython Test 위한 접근 방법 jython 접근 명령: ...\Oracle_ODI1\oracledi.sdk\lib>java -jar jython.jar Error 발생시 Case 1: LookupError: unknown encoding 'ms949' 해결책: 접근시 encoding 방식을 지정 java -jar jython.jar -C utf-8 더보기

티스토리툴바