ITS_OP/SRC - 스마트교차로 테이블 연계 이전 소스/SQL/서비스링크정보조회.sql

SELECT IFSC_ID           ,
       IFSC_NM           ,
       DRCT_CD           ,
       STRT_NM           ,
       END_NM            ,
       SECT_LNGT         ,
       EXTR_CNCT_SECT_YN ,
       DEL_YN            ,
       RMRK              ,
       F_NODE_ID         ,
       T_NODE_ID         ,
       SECT_GRAD_CD      ,
       AREA_CD           ,
       DECODE( AREA_CD, 'LAT001', 'Y', 'N' ) REGN_YN
  FROM TB_IFSC
 ORDER BY IFSC_ID

-- ź­şń˝ş¸ľĹŠ ą¸źşÁ¤ş¸
SELECT IFSC_ID, LINK_ID, ORD 
  FROM TB_IFSC_LINK_RLTN
ORDER BY IFSC_ID, ORD