메뉴 건너뛰기

검색창 닫기

tnt_db

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

박상현 2006.11.07 16:50 조회 수 : 3690 추천: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;
이 게시물을
이 글의 추천인 목록 수정 삭제 목록
번호 제목 글쓴이 날짜 조회 수
» 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기 박상현 2006.11.07 3690
105 PL/SQL에서 쿼리시 Array Processing 처리방법 박상현 2006.10.27 3622
104 시간선분(선분이력)의 합집합 구하기 박상현 2006.06.13 5159
103 최대공약수, 최소공배수 구하기 박상현 2006.06.13 3839
102 문자열에서 특정 단어 갯수 구하기 박상현 2006.06.13 3573
101 소수(prime number) 구하기 박상현 2006.06.13 3425
100 달력 생성 쿼리 박상현 2006.06.13 3345
99 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (2) 박상현 2006.06.13 3968
98 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (1) 박상현 2006.06.13 3697
97 문자열 행으로 분리하기 박상현 2006.06.13 3827
96 TABLE,COLUMN,PROCEDURE 이름을 확인할때... 원우석 2006.03.10 3114
95 NESTED TABLE과 VARRAY사용법과 다른점 박상현 2005.11.03 8834
94 데이타 모델링(이화식 강의) 부분 목차정리. 박상현 2004.06.22 3361
93 oracle 8i제공 explan table 생성 script 박상현 2004.05.08 2662
92 toad에서 사용가능한 explan_table생성 script 박상현 2004.05.08 6683
91 ORACLE -> MSSQL 시 LPAD 처리 운영자 2003.10.08 4268
90 plan table(sql실행계획) 보는 select문 운영자 2003.01.28 3988
89 java에서 array처리 방법 운영자 2003.01.27 6189
88 효율적인 25가지 SQL작성법 운영자 2003.01.04 2948
87 중복 data는 처음에만 display 하게 하는 방법 운영자 2002.11.23 2965
쓰기 태그
위로