Oracle 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기

박상현 2006.11.07 16:50 조회 수 : 3608 추천:25

CREATE TABLE FOIS_CHECKPOINT
(
  CHK_NAME_START  VARCHAR2(50 BYTE),
  CHK_NAME_DEST   VARCHAR2(50 BYTE),
  DIST            NUMBER,
  GUBUN           VARCHAR2(1 BYTE)
)

CREATE UNIQUE INDEX "fois_checkpint_pk" ON FOIS_CHECKPOINT
(CHK_NAME_START, CHK_NAME_DEST)
LOGGING
TABLESPACE USERS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;

ALTER TABLE FOIS_CHECKPOINT ADD (
  CONSTRAINT "fois_checkpint_pk" PRIMARY KEY (CHK_NAME_START, CHK_NAME_DEST)
    USING INDEX
    TABLESPACE USERS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
               ));

==========================

INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AGAVO', 'GONAV', 20, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GONAV', 'AGAVO', 20, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GONAV', 'ANSIM', 23.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ANSIM', 'GONAV', 23.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GONAV', 'ARIVA', 66.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ARIVA', 'GONAV', 66.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ARIVA', 'BOGAN', 32.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOGAN', 'ARIVA', 32.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOGAN', 'BELMI', 24.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BELMI', 'BOGAN', 24.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ANSIM', 'NOPIK', 39.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NOPIK', 'ANSIM', 39.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NOPIK', 'GUTIK', 29, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GUTIK', 'NOPIK', 29, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GUTIK', 'DAEBU', 14, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAEBU', 'GUTIK', 14, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAEBU', 'SEL', 18, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'DAEBU', 18, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NOPIK', 'DAPTO', 41.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAPTO', 'NOPIK', 41.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAPTO', 'SEL', 19.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'DAPTO', 19.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'ENKAS', 22.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ENKAS', 'SEL', 22.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ENKAS', 'KARBU', 13.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KARBU', 'ENKAS', 13.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KARBU', 'JINBU', 44.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'JINBU', 'KARBU', 44.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'JINBU', 'KAE', 8.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAE', 'JINBU', 8.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAE', 'SORAK', 30.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SORAK', 'KAE', 30.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SORAK', 'LANAT', 120.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LANAT', 'SORAK', 120.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LANAT', 'KABKI', 70, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KABKI', 'LANAT', 70, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KABKI', 'MIHO', 25, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MIHO', 'KABKI', 25, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAE', 'IGLUT', 40.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGLUT', 'KAE', 40.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGLUT', 'INTOS', 84.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'INTOS', 'IGLUT', 84.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'INTOS', 'TENAS', 20, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TENAS', 'INTOS', 20, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TENAS', 'KANSU', 73.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KANSU', 'TENAS', 73.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SORAK', 'WONDO', 19.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'WONDO', 'SORAK', 19.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'WONDO', 'BUKDO', 47.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BUKDO', 'WONDO', 47.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BUKDO', 'KPO', 21.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'BUKDO', 21.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'NAMDO', 36.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMDO', 'KPO', 36.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMDO', 'PSN', 19.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'NAMDO', 19.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'KALMA', 11.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALMA', 'SEL', 11.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALMA', 'KAKSO', 18.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAKSO', 'KALMA', 18.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAKSO', 'BULLS', 11.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BULLS', 'KAKSO', 11.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BULLS', 'GOTLO', 18.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOTLO', 'BULLS', 18.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOTLO', 'BIGOB', 11.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BIGOB', 'GOTLO', 11.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BIGOB', 'CUN', 9.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CUN', 'BIGOB', 9.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CUN', 'PAROT', 30.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PAROT', 'CUN', 30.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PAROT', 'KPO', 38, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'PAROT', 38, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'SAPRA', 61.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPRA', 'KPO', 61.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPRA', 'STAGE', 97, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'STAGE', 'SAPRA', 97, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'STAGE', 'MIHO', 20, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MIHO', 'STAGE', 20, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'BELMI', 12.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BELMI', 'SEL', 12.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BELMI', 'OSN', 7.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'BELMI', 7.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'SINSA', 21.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SINSA', 'OSN', 21.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SINSA', 'AKLAS', 10, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AKLAS', 'SINSA', 10, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SINSA', 'CHO', 10.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CHO', 'SINSA', 10.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AKLAS', 'VAPKA', 22, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VAPKA', 'AKLAS', 22, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CHO', 'VAPKA', 22, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VAPKA', 'CHO', 22, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VAPKA', 'PATLA', 14.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATLA', 'VAPKA', 14.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATLA', 'BOMRA', 39.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOMRA', 'PATLA', 39.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATLA', 'TGU', 39, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'PATLA', 39, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOMRA', 'KALOD', 20.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALOD', 'BOMRA', 20.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'KALOD', 21, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALOD', 'TGU', 21, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALOD', 'PSN', 25.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'KALOD', 25.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'APELA', 26.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'APELA', 'PSN', 26.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'APELA', 'IKI', 64, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKI', 'APELA', 64, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'APELA', 'IKE', 64, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKE', 'APELA', 64, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'NAMJA', 22, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMJA', 'OSN', 22, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'NUMDA', 21.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NUMDA', 'OSN', 21.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMJA', 'PATRO', 19, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATRO', 'NAMJA', 19, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NUMDA', 'PATRO', 21.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATRO', 'NUMDA', 21.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATRO', 'BOTKI', 29, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOTKI', 'PATRO', 29, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PATRO', 'DADGA', 29.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DADGA', 'PATRO', 29.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOTKI', 'ALADI', 24, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ALADI', 'BOTKI', 24, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DADGA', 'ALADI', 22.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ALADI', 'DADGA', 22.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ALADI', 'KWA', 23.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'ALADI', 23.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'IPDAS', 52.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IPDAS', 'KWA', 52.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IPDAS', 'CJU', 52, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CJU', 'IPDAS', 52, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CJU', 'ATOTI', 215.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ATOTI', 'CJU', 215.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KUZ', 'BOTKI', 13, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOTKI', 'KUZ', 13, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KUZ', 'DADGA', 13.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DADGA', 'KUZ', 13.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOTKI', 'OKISA', 35, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OKISA', 'BOTKI', 35, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DADGA', 'OKISA', 35.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OKISA', 'DADGA', 35.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OKISA', 'BOMRA', 47.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOMRA', 'OKISA', 47.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OKISA', 'TGU', 47, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'OKISA', 47, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BOMRA', 'LATEP', 24.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LATEP', 'BOMRA', 24.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'LATEP', 24, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LATEP', 'TGU', 24, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LATEP', 'KPO', 19.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'LATEP', 19.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'IGDOK', 54.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGDOK', 'KWA', 54.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGDOK', 'TGU', 41.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'IGDOK', 41.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'TEDAN', 24.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TEDAN', 'KWA', 24.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TEDAN', 'VENUS', 13.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'TEDAN', 13.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TEDAN', 'NIKET', 13.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'TEDAN', 13.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'AMICK', 44.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AMICK', 'VENUS', 44.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'SAPDI', 44.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPDI', 'VENUS', 44.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'AMICK', 44.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AMICK', 'NIKET', 44.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'SAPDI', 44.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPDI', 'NIKET', 44.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AMICK', 'PSN', 24.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'AMICK', 24.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPDI', 'PSN', 24.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'SAPDI', 24.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ESBIS', 'POTET', 64, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'POTET', 'ESBIS', 64, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'POTET', 'RUGMA', 14, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RUGMA', 'POTET', 14, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RUGMA', 'CJU', 55.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CJU', 'RUGMA', 55.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CJU', 'MAKET', 47.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MAKET', 'CJU', 47.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MAKET', 'GOSBO', 30.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOSBO', 'MAKET', 30.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOSBO', 'TOPAX', 46.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TOPAX', 'GOSBO', 46.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TOPAX', 'PSN', 32.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'TOPAX', 32.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'BULGA', 63.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BULGA', 'PSN', 63.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BULGA', 'AGSUS', 64.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AGSUS', 'BULGA', 64.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AGSUS', 'INTOS', 47.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'INTOS', 'AGSUS', 47.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'CJU', 'TAMNA', 35.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TAMNA', 'CJU', 35.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TAMNA', 'SAMDO', 49.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAMDO', 'GOURA', 49, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOURA', 'SAMDO', 49, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOURA', 'IKE', 25, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKE', 'GOURA', 25, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'GOURA', 'IKI', 25, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKI', 'GOURA', 25, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKE', 'DGC', 31, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DGC', 'IKE', 31, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IKI', 'DGC', 31, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DGC', 'IKI', 31, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'INVOK', 25.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'INVOK', 'PSN', 25.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'INVOK', 'BEETL', 40, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BEETL', 'INVOK', 40, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BEETL', 'DGC', 45, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DGC', 'BEETL', 45, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'KALEK', 43.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALEK', 'PSN', 43.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALEK', 'OPERA', 139, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OPERA', 'KALEK', 139, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OPERA', 'MIHO', 19, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MIHO', 'OPERA', 19, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BELMI', 'ENKAS', 24.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ENKAS', 'BELMI', 24.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'ENKAS', 29.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ENKAS', 'OSN', 29.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NUMDA', 'KAKSO', 32.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAKSO', 'NUMDA', 32.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAPTO', 'OSN', 28.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'OSN', 'DAPTO', 28.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKSI', 'DAPTO', 10.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAPTO', 'RKSI', 10.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NCN', 'DAPTO', 10.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DAPTO', 'NCN', 10.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKSS', 'SEL', 12.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SEL', 'RKSS', 12.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTU', 'SINSA', 10.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SINSA', 'RKTU', 10.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKNY', 'KAE', 29.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAE', 'RKNY', 29.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'YAG', 'KAE', 29.8, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAE', 'YAG', 29.8, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKNY', 'KAN', 30.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAN', 'RKNY', 30.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'YAG', 'KAN', 30.3, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KAN', 'YAG', 30.3, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJK', 'DADGA', 13.9, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'DADGA', 'RKJK', 13.9, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKNW', 'KARBU', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KARBU', 'RKNW', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'HGS', 'KARBU', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KARBU', 'HGS', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPK', 'PSN', 8.1, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PSN', 'RKPK', 8.1, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPK', 'KALOD', 17.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALOD', 'RKPK', 17.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPC', 'IPDAS', 52, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IPDAS', 'RKPC', 52, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPC', 'MAKET', 47.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MAKET', 'RKPC', 47.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPC', 'TAMNA', 35.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TAMNA', 'RKPC', 35.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPC', 'RUGMA', 55.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RUGMA', 'RKPC', 55.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPC', 'ATOTI', 215.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ATOTI', 'RKPC', 215.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTN', 'LATEP', 24.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LATEP', 'RKTN', 24.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PALTA', 'TGU', 39.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TGU', 'PALTA', 39.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTN', 'PALTA', 39.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PALTA', 'RKTN', 39.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTN', 'KALOD', 20.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KALOD', 'RKTN', 20.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTN', 'IGDOK', 41.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGDOK', 'RKTN', 41.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJJ', 'IGDOK', 54.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IGDOK', 'RKJJ', 54.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJJ', 'ALADI', 23.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'ALADI', 'RKJJ', 23.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJJ', 'TEDAN', 24.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'TEDAN', 'RKJJ', 24.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJJ', 'IPDAS', 52.4, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'IPDAS', 'RKJJ', 52.4, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJY', 'VENUS', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'RKJY', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'RKJY', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJY', 'NIKET', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'YSU', 'VENUS', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'YSU', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'YSU', 23.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'YSU', 'NIKET', 23.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'USN', 'NAMDO', 16.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMDO', 'USN', 16.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPU', 'NAMDO', 16.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMDO', 'RKPU', 16.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPU', 'KPO', 23.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'RKPU', 23.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'USN', 'KPO', 23.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KPO', 'USN', 23.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTH', 'BUKDO', 21.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'BUKDO', 'RKTH', 21.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTH', 'PAROT', 38, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'PAROT', 'RKTH', 38, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTH', 'LATEP', 19.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'LATEP', 'RKTH', 19.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKTH', 'NAMDO', 36.7, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NAMDO', 'RKTH', 36.7, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAC', 'VENUS', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'SAC', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPS', 'VENUS', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'VENUS', 'RKPS', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAC', 'NIKET', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'SAC', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPS', 'NIKET', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'NIKET', 'RKPS', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAC', 'AMICK', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AMICK', 'SAC', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPS', 'AMICK', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'AMICK', 'RKPS', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAC', 'SAPDI', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPDI', 'SAC', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKPS', 'SAPDI', 22.5, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAPDI', 'RKPS', 22.5, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKJM', 'KWA', 25.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'RKJM', 25.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MKP', 'KWA', 25.6, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KWA', 'MKP', 25.6, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'RKSS', 'MALPA', 56.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MALPA', 'RKSS', 56.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'KIP', 'MALPA', 56.2, '1');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'MALPA', 'KIP', 56.2, '2');
INSERT INTO FOIS_CHECKPOINT ( CHK_NAME_START, CHK_NAME_DEST, DIST,
GUBUN ) VALUES (
'SAMDO', 'TAMNA', 49.8, '2');
COMMIT;

CREATE OR REPLACE FUNCTION get_dist(s_airport IN varchar2, d_airport IN varchar2)
RETURN NUMBER
IS

dist_sum NUMBER;
tmp_dist NUMBER;

--idx number;
idx PLS_INTEGER;

tmp_str varchar2(300);

TYPE airport_rec_table_type IS TABLE OF fois_checkpoint.chk_name_start%TYPE INDEX BY BINARY_INTEGER;
airport_rec airport_rec_table_type;

CURSOR split_str(comma_str varchar2) IS
-- 문자열을 구분자 기준으로 나누기
        SELECT  SUBSTR (aa,
              INSTR (aa, ',', 1, LEVEL) + 1,
              INSTR (aa, ',', 1, LEVEL + 1) - INSTR (aa, ',', 1, LEVEL)
              - 1
             ) sub
              FROM (SELECT ',' || comma_str || ',' aa
                      FROM DUAL)
        CONNECT BY LEVEL <= LENGTH (aa) - LENGTH (REPLACE (aa, ',')) - 1;

BEGIN
    dist_sum := 0;
    tmp_dist := 0;
    idx := 1;

   -- 같은 값이 들어오면 0으로 return
   if s_airport = d_airport then
    return 0;
   end if;

   -- start와 dest를 바로 확인가능하면 바로 리턴함
   begin

    select dist into dist_sum
    from fois_checkpoint where gubun='1' and chk_name_start = s_airport and chk_name_dest = d_airport;

    if dist_sum <> 0 then return dist_sum;
    end if;

    EXCEPTION
     WHEN NO_DATA_FOUND THEN
         begin
           select dist into dist_sum
           from fois_checkpoint where gubun='2' and chk_name_start = s_airport and chk_name_dest = d_airport;

           if dist_sum <> 0 then return dist_sum;
           end if;
         end;

   end;



   -- 해당되는 문자열(gubun=1인경우, 위에서 밑으로...)
   begin
        select
        d_str into tmp_str
        from
        (
         select CONNECT_BY_ISCYCLE cbi,
         level,chk_name_start, chk_name_dest, dist,
         substr(SYS_CONNECT_BY_PATH (chk_name_start, ','),2) s_str,
         s_airport||','||substr(SYS_CONNECT_BY_PATH (chk_name_dest, ','),2) d_str
         from fois_checkpoint
                 connect by nocycle chk_name_start=prior chk_name_dest
                         and prior chk_name_start <> chk_name_dest
                         and gubun = '1'
                         and gubun = prior gubun
                        start with chk_name_start = s_airport
        )
        where 1=1
          and chk_name_dest = d_airport
          and cbi = 0
          and rownum=1;

    --값을 찍어봄
    --DBMS_OUTPUT.PUT_LINE ('처리할 문자열 :  ' || tmp_str);

-- 정방향으로 찾아서 값이 없으면 역방향으로 찾음(gubun=2)
    EXCEPTION
     WHEN NO_DATA_FOUND THEN
         begin
             -- 해당되는 문자열(gubun=2인경우, 밑에서 위로...)
                select
                d_str into tmp_str
                from
                (
                 select CONNECT_BY_ISCYCLE cbi,
                 level,chk_name_start, chk_name_dest, dist,
                 substr(SYS_CONNECT_BY_PATH (chk_name_start, ','),2) s_str,
                 s_airport||','||substr(SYS_CONNECT_BY_PATH (chk_name_dest, ','),2) d_str
                 from fois_checkpoint
                         connect by nocycle chk_name_start=prior chk_name_dest
                                 and prior chk_name_start <> chk_name_dest
                                 and gubun = '2'
                                 and gubun = prior gubun
                                start with chk_name_start = s_airport
                )
                where 1=1
                  and chk_name_dest = d_airport
                  and cbi = 0
                  and rownum=1;
         end;

   end;

    -- 값을 뽑아서 배열에 담음
    BEGIN
        OPEN split_str(tmp_str);
        FETCH split_str BULK COLLECT INTO airport_rec;
        CLOSE split_str;
    END;

        --값을 찾아서 누적
    LOOP EXIT WHEN idx = airport_rec.count;

       select dist into tmp_dist from fois_checkpoint
        where chk_name_dest = airport_rec(idx)
          and chk_name_start = airport_rec(idx+1)
          and rownum = 1;

        dist_sum := dist_sum + tmp_dist;
        tmp_dist := 0;
        idx := idx+1;

   END LOOP;

   return dist_sum;

END get_dist;

이 게시물을

수정 삭제 목록

» 편집 도구모음 건너뛰기

하이퍼링크

새 창으로
특수문자 삽입
선택한 기호

칸 수 지정

행
열

표 속성 지정

테두리 굵기
테두리 색
표 배경색

입력창 크기 자동조절

문서 첨부 제한 : 0Byte/ 10.00MB
파일 크기 제한 : 2.00MB (허용 확장자 : *.*)

글쓴이 비밀번호 홈페이지

번호	제목	글쓴이	날짜	조회 수
126	test''' ' '' '' ''''""" ''''''''	구퍼	2011.03.07	4314
125	테이블 열항목을 행항목으로 변경하는 팁	구퍼	2011.01.11	8675
124	오라클 DB 링크 만들기	구퍼	2011.01.06	6510
123	select -> update 구문 샘플	구퍼	2010.01.21	5696
122	Instant Client 사용법	구퍼	2009.12.30	5894
121	row데이터 연결하여 조회	구퍼	2009.03.31	3663
120	데이타에 한글로 공백이 있는 경우 값을 가져오지 못하고 오류가 발생하는 경우 처리	구퍼	2009.03.23	5584
119	mssql update예제(select ~ update)	구퍼	2008.10.31	6115
118	Update ~ Select 구문 예제	구퍼	2008.10.31	4432
117	oracle 10g tnsnames.ora, listener.ora위치	구퍼	2008.09.29	4312
116	Conditions	구퍼	2008.09.17	5544
115	Basic Delete Statements	구퍼	2008.09.17	4557
114	Basic Update Statements	구퍼	2008.09.17	4527
113	문자열 연결, 날짜 변환, 오늘 구하기	구퍼	2008.09.10	4275
112	현재의 년월일시분초 구하기	구퍼	2008.09.10	5549
111	분산트랜젝션 가능여부 확인 방법	하늘과컴	2008.05.29	4960
110	순환구조에서 임시테이블에 하위 조직을 엮어서 넣는 프로시져	하늘과컴	2007.10.01	5204
»	최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기	박상현	2006.11.07	3608
108	PL/SQL에서 쿼리시 Array Processing 처리방법	박상현	2006.10.27	3469
107	시간선분(선분이력)의 합집합 구하기	박상현	2006.06.13	4931

쓰기 태그

첫 페이지 1 2 3 4 5 6 7 끝 페이지

tnt_db

Oracle 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기

댓글 0

하이퍼링크

특수문자 삽입

칸 수 지정

표 속성 지정

tnt_db

Oracle 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기

댓글 0

하이퍼링크

특수문자 삽입

칸 수 지정

표 속성 지정

LOGIN