live a live

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