
SELECT ID, CLCT_DT, LOG_TYPE, LOG_ID, LOG_ADDRESS 
  FROM TB_RSE_LOG_HS 
 WHERE CLCT_DT BETWEEN '20140101000000' AND '20141231235959'
 ORDER BY TO_NUMBER(ID), CLCT_DT
 
