ITS-OP/SRC/PLUGIN/13.TRAFFIC-ANALYSIS-SUPPORT/TAS0020M/패턴정보테스트데이터 입력.sql

INSERT INTO TB_IFSC_HH_PTRN
SELECT IFSC_ID, '201801', 'DTW1', '0300',  0, ROUND(DBMS_RANDOM.VALUE(1, 100),0), 0, 0, 0
FROM (
SELECT X.ATRD_ID, X.ATRD_NM, X.DRCT_CD, X.DRCT_NM, 
       Y.ROAD_ORD, Y.IFSC_ORD, Y.IFSC_ID, Y.IFSC_NM, Y.STRT_NM, Y.END_NM, Y.SECT_LNGT
  FROM TB_ATRD X, 
       (SELECT A.ATRD_ID, A.ORD AS ROAD_ORD, A.ROAD_ID, B.IFSC_ID, B.ORD AS IFSC_ORD, C.IFSC_NM, C.STRT_NM, C.END_NM, C.SECT_LNGT
          FROM TB_ATRD_ROAD_RLTN A, TB_ROAD_IFSC_RLTN B, TB_IFSC C
         WHERE A.ROAD_ID = B.ROAD_ID
           AND B.IFSC_ID = C.IFSC_ID
           AND A.ATRD_ID IN (SELECT ATRD_ID FROM TB_ATRD WHERE TRIM(ATRD_NM) = '±¹µµ46È£¼±')
        ) Y
 WHERE X.ATRD_ID = Y.ATRD_ID
   AND X.ATRD_ID IN (SELECT ATRD_ID FROM TB_ATRD WHERE TRIM(ATRD_NM) = '±¹µµ46È£¼±')
 ORDER BY X.ATRD_ID, Y.ROAD_ORD, Y.IFSC_ORD
 )