live a live

*** %CATALINA_HOME%\conf\web.xml - 99번째 ~ 109번째 줄 주석 해제 invoker org.apache.catalina.servlets.InvokerServlet debug 0 2 - 348번째 ~ 351번째 줄 주석 해제 invoker /servlet/* *** %CATALINA_HOME%\%conf\context.xml - 태그의 수정 이 설정을 빠트리면 tomcat java.lang.reflect.InvocationTargetException 이 발생한다.

* 중복체크 SELECT COUNT(*) AS cnt , po_no , po_dt_lno FROM gr_dt WHERE del_yn = 'N' GROUP BY po_no , po_dt_lno HAVING COUNT(*) > 1 * 중복제거 DELETE FROM gr_dt A WHERE ROWID > (SELECT MIN(ROWID) FROM gr_dt B WHERE A.po_no = B.po_no AND A.po_dt_lno = B.po_dt_lno AND DEL_YN= 'N') AND del_yn = 'N'

* ETL & ETT - ETL : Extract, Transform, Load - ETT : Extract, Transform, Transport * ETL Tool - 상용 : 1. MS : SSIS, 2. IBM : DataStage 3. Informatica - 오픈소스 : 1. Pentaho Data Integration (Kettle, http://kettle.pentaho.com) Spoon for GUI, Kitchen and Pan for Console, Carte for Remote and Distirbucted Environment 2. Talend Open Studio 3. CloverETL(www.cloveretl.com/) 4. ETL integrator(http://www.gl..

Query> SELECT SYSDATE , TO_TIMESTAMP(SYSDATE) , CAST(SYSDATE AS TIMESTAMP) , CURRENT_TIMESTAMP , CURRENT_TIMESTAMP(0) , SYSTIMESTAMP , LOCALTIMESTAMP , DBTIMEZONE FROM DUAL; Result> SYSDATE 2011/12/02 13:31:03 TO_TIMESTAMP(SYSDATE) 2011/12/02 00:00:00 CAST(SYSDATEASTIMESTAMP) 2011/12/02 13:31:03 CURRENT_TIMESTAMP 2011/12/02 13:31:03 +09:00 CURRENT_TIMESTAMP(0) 2011/12/02 13:31:04 +09:00 SYSTIMES..