소통정보조회.sql 636 B

12345678910
  1. SELECT LINK_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, MISS_YN, PRCN_SPED, SMTH_SPED, ADJS_SPED, PTRN_SPED, PRCN_SORC, ADJS_SORC, DATA_NUM,
  2. (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT
  3. FROM TB_LINK_TRAF
  4. WHERE TO_DATE( PRCN_DT, 'YYYYMMDDHH24MISS' ) > sysdate - 10 / 1440
  5. UNION
  6. SELECT LINK_ID, PRCN_DT, TFVL, SPED, OCPY_RATE, TRVL_HH, CMTR_GRAD_CD, MISS_YN, PRCN_SPED, SMTH_SPED, ADJS_SPED, PTRN_SPED, PRCN_SORC, ADJS_SORC, DATA_NUM,
  7. (SELECT MAX(PRCN_DT) FROM TB_LINK_TRAF) MPRCN_DT
  8. FROM TB_LINK_TRAF
  9. WHERE TO_DATE( PRCN_DT, 'YYYYMMDDHH24MISS' ) <= sysdate - 10 / 1440
  10. ORDER BY LINK_ID, PRCN_DT