메뉴 건너뛰기

검색창 닫기

tnt_db

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;
이 게시물을
수정 삭제 목록
번호 제목 글쓴이 날짜 조회 수
86 LENGTH/LENGTHB,SUBSTR/SUBSTRB,INSTR/INSTRB 운영자 2002.09.18 4050
85 PARAMETER값 변경에따른 유연한 GROUP BY 운영자 2002.09.18 4040
84 최대값과 최소값을 뺀 평균 운영자 2002.09.18 3941
83 한번 읽은 테이블로 백분율 구하기 운영자 2002.09.18 3834
82 plan table(sql실행계획) 보는 select문 운영자 2003.01.28 3831
81 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (2) 박상현 2006.06.13 3816
80 sybase DB에서 파일로 백업을 받구 그파일을 다시 DB2로 임포트하는방법 원우석 2004.07.31 3748
79 특정문자까지의 왼쪽 문자열 반환 function 운영자 2002.10.18 3743
78 row데이터 연결하여 조회 구퍼 2009.03.31 3663
77 년중 몇번째 주간인지 알아내기(FUNCTION) - ORACLE이 제공하는 것과 다름 운영자 2002.09.17 3630
» 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기 박상현 2006.11.07 3608
75 다수 NULL 허용 COLUMN의 명칭을 가져올때 운영자 2002.09.18 3572
74 문자열 행으로 분리하기 박상현 2006.06.13 3552
73 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (1) 박상현 2006.06.13 3537
72 복제를이용한 합계계에서 비율계산 운영자 2002.09.18 3534
71 RECORD단위 DATA를 COLUMN단위로 운영자 2002.09.18 3507
70 sql 문 실행명령 원우석 2004.07.31 3500
69 최대공약수, 최소공배수 구하기 박상현 2006.06.13 3479
68 PL/SQL에서 쿼리시 Array Processing 처리방법 박상현 2006.10.27 3469
67 반올림 DATA의 오차보정 운영자 2002.09.18 3463
쓰기 태그
위로