123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 |
- SELECT TO_NUMBER(CASE WHEN EXISTS (SELECT 1 FROM TB_RSE_OFFR_SECT_MNGM)
- THEN (SELECT TRIM(MAX(TO_NUMBER(OFFR_SECT_ID)) + 1)
- FROM TB_RSE_OFFR_SECT_MNGM)
- ELSE '1' END) AS NEWID
- FROM DUAL
- SELECT TO_NUMBER(CASE WHEN EXISTS (SELECT 1 FROM TB_RSE_OFFR_SECT_MNGM)
- THEN (SELECT TRIM(MAX(TO_NUMBER(OBU_ENTR_DRCT_NMBR)) + 1)
- FROM TB_RSE_OFFR_SECT_MNGM
- WHERE ID = '')
- ELSE '1' END) AS AUTONUM
- FROM DUAL
- SELECT A.OFFR_SECT_ID, A.OFFR_DRCT_NM, A.CNGS_BASI_SPED, A.DELY_BASI_SPED,
- A.ID, A.OBU_ENTR_DRCT_NMBR, C.PRE_ID, C.IXR_DRCT_NUM,
- (SELECT ISTL_LCTN_NM FROM TB_RSE_MSTR WHERE ID = A.ID) TARGETNM,
- (SELECT ISTL_LCTN_NM FROM TB_RSE_MSTR WHERE ID = C.PRE_ID) PRENM
- FROM TB_RSE_OFFR_SECT_MNGM A,
- TB_RSE_OFFR_DRCT_INFR C
- WHERE A.ID = C.ID(+)
- AND A.OBU_ENTR_DRCT_NMBR = C.OBU_ENTR_DRCT_NMBR(+)
- ORDER BY TO_NUMBER(A.OFFR_SECT_ID)
- --RSE 제공 구간 관리(정보제공구간정보)
- SELECT OFFR_SECT_ID,
- OFFR_DRCT_NM,
- CNGS_BASI_SPED,
- DELY_BASI_SPED,
- ID,
- OBU_ENTR_DRCT_NMBR
- FROM TB_RSE_OFFR_SECT_MNGM
- ORDER BY OFFR_SECT_ID
- --RSE 제공 구간 정보(링크레벨2)
- SELECT OFFR_SECT_ID,
- IFSC_ID,
- ORD
- FROM TB_RSE_OFFR_SECT_INFR
- --RSE 제공 방향 정보
- SELECT ID,
- OBU_ENTR_DRCT_NMBR,
- PRE_ID,
- IXR_DRCT_NUM
- FROM TB_RSE_OFFR_DRCT_INFR
-
- SELECT A.OFFR_SECT_ID, A.OFFR_DRCT_NM, A.CNGS_BASI_SPED, A.DELY_BASI_SPED, A.ID, A.OBU_ENTR_DRCT_NMBR,
- B.IFSC_ID, B.ORD, C.PRE_ID, C.IXR_DRCT_NUM,
- D.F_NODE_ID, (SELECT NODE_NAME FROM TB_NODE WHERE NODE_ID = D.F_NODE_ID) F_NODENAME,
- D.T_NODE_ID, (SELECT NODE_NAME FROM TB_NODE WHERE NODE_ID = D.T_NODE_ID) T_NODENAME,
- (SELECT ISTL_LCTN_NM FROM TB_RSE_MSTR WHERE ID = A.ID) TARGETNM,
- (SELECT ISTL_LCTN_NM FROM TB_RSE_MSTR WHERE ID = C.PRE_ID) PRENM
- FROM TB_RSE_OFFR_SECT_MNGM A,
- TB_RSE_OFFR_SECT_INFR B,
- TB_RSE_OFFR_DRCT_INFR C,
- TB_IFSC D
- WHERE A.OFFR_SECT_ID = B.OFFR_SECT_ID(+)
- AND A.ID = C.ID(+)
- AND A.OBU_ENTR_DRCT_NMBR = C.OBU_ENTR_DRCT_NMBR(+)
- AND B.IFSC_ID = D.IFSC_ID(+)
- ORDER BY TO_NUMBER(A.OFFR_SECT_ID), B.ORD
- DELETE TB_RSE_OFFR_SECT_INFR WHERE OFFR_SECT_ID = :p01
- DELETE TB_RSE_OFFR_INFR_HS WHERE OFFR_SECT_ID = :p01
- DELETE TB_RSE_OFFR_SECT_MNGM WHERE OFFR_SECT_ID = :p01
- SELECT * FROM TB_RSE_OFFR_DRCT_INFR
|