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;
댓글 0
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 94 | 테이블 열항목을 행항목으로 변경하는 팁 | 구퍼 | 2011.01.11 | 8835 |
| 93 | 오라클 DB 링크 만들기 | 구퍼 | 2011.01.06 | 6826 |
| 92 | select -> update 구문 샘플 | 구퍼 | 2010.01.21 | 5936 |
| 91 | Instant Client 사용법 | 구퍼 | 2009.12.30 | 6051 |
| 90 | Conditions | 구퍼 | 2008.09.17 | 5844 |
| 89 | Basic Delete Statements | 구퍼 | 2008.09.17 | 4671 |
| 88 | Basic Update Statements | 구퍼 | 2008.09.17 | 4622 |
| 87 | Unix, Oracle, Pro*C작성 입찰공고 | 운영자 | 2003.06.05 | 4458 |
| 86 | Unix, Oracle, Pro*C작성 구인구직게시판 | 운영자 | 2003.06.05 | 4887 |
| 85 | Unix, Oracle, Pro*C작성 자유게시판 | 운영자 | 2003.06.05 | 4745 |
| » | 최단거리찾기 혹은 멀리 떨어진 두지점간의 거리의 합구하기 | 박상현 | 2006.11.07 | 3690 |
| 83 | PL/SQL에서 쿼리시 Array Processing 처리방법 | 박상현 | 2006.10.27 | 3622 |
| 82 | 시간선분(선분이력)의 합집합 구하기 | 박상현 | 2006.06.13 | 5159 |
| 81 | 최대공약수, 최소공배수 구하기 | 박상현 | 2006.06.13 | 3839 |
| 80 | 문자열에서 특정 단어 갯수 구하기 | 박상현 | 2006.06.13 | 3573 |
| 79 | 소수(prime number) 구하기 | 박상현 | 2006.06.13 | 3425 |
| 78 | 달력 생성 쿼리 | 박상현 | 2006.06.13 | 3345 |
| 77 | 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (2) | 박상현 | 2006.06.13 | 3968 |
| 76 | 다중 Row 결과를 단일행으로 컴마로 분리해 출력하는 방법 (1) | 박상현 | 2006.06.13 | 3697 |
| 75 | 문자열 행으로 분리하기 | 박상현 | 2006.06.13 | 3827 |