ITS_OP/SRC/SQL/돌발정보 조회.sql

SELECT * FROM TB_INCD_OCRR

SELECT A.LINK_ID, A.DETC_DT, A.CLCT_SPED_AVRG, A.ESTM_SPED_AVRG,  
       A.REAL_YN, B.X_CRDN, B.Y_CRDN, C.ROAD_NAME                 
  FROM TB_INCD_ESTM_SECT A, TB_LINK_VRTX B, TB_LINK C             
 WHERE A.LINK_ID = B.LINK_ID                                      
   AND A.LINK_ID = C.LINK_ID                                      
   AND B.ORD = '1'                                                

SELECT * 
  FROM TB_INCD_OCRR_VMS 
 WHERE VMS_DSPL_YN = 'Y'


SELECT LPAD(NVL(MAX(SUBSTR(INCD_OCRR_ID, -9)), '000000000') + 1, 9, '0') AS NEWID 
  FROM TB_INCD_OCRR                                                      
 WHERE SUBSTR(INCD_OCRR_ID, 1, 3) = 'L24'