CREATE SCRIPT:

CREATE TABLE FAKRU_TEST
(
  COL_1         CHAR(1 BYTE),
  COL_2         VARCHAR2(7 BYTE),
  COL_3         VARCHAR2(3 BYTE),
  COL_4         CHAR(2 BYTE),
  COL_5         VARCHAR2(1 BYTE),
  COL_6         CHAR(9 BYTE),
  METRIC        VARCHAR2(18 BYTE),
  WEEK_NUM      NUMBER,
  MAP_POSN_NBR  NUMBER(5),
  CNT           NUMBER
);



INSERT SCRIPT:

Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100402, 1, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100326, 2, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100319, 3, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100312, 4, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100305, 5, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100226, 6, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000001', 20100219, 7, 
    2);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000001', 20100212, 8, 
    2);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100205, 9, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100129, 10, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100122, 11, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100115, 12, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100108, 13, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20100101, 14, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091225, 15, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091218, 16, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091211, 17, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091204, 18, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091127, 19, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091120, 20, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091113, 21, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091106, 22, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091030, 23, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091023, 24, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091016, 25, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091009, 26, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20091002, 27, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090925, 28, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090918, 29, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090911, 30, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090904, 31, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090828, 32, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090821, 33, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090814, 34, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090807, 35, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090731, 36, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090724, 37, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090717, 38, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090710, 39, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090703, 40, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090626, 41, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090619, 42, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090612, 43, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090605, 44, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090529, 45, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090522, 46, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090515, 47, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090508, 48, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090501, 49, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090424, 50, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090417, 51, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090410, 52, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090403, 53, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090327, 54, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090320, 55, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090313, 56, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090306, 57, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090227, 58, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090220, 59, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090213, 60, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090206, 61, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090130, 62, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090123, 63, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090116, 64, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090109, 65, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20090102, 66, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081226, 67, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081219, 68, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081212, 69, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081205, 70, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081128, 71, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081121, 72, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081114, 73, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081107, 74, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081031, 75, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081024, 76, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081017, 77, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081010, 78, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20081003, 79, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080926, 80, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080919, 81, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080912, 82, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080905, 83, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080829, 84, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080822, 85, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080815, 86, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080808, 87, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080801, 88, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080725, 89, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080718, 90, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080711, 91, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080704, 92, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080627, 93, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080620, 94, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080613, 95, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080606, 96, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080530, 97, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080523, 98, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080516, 99, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080509, 100, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080502, 101, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080425, 102, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080418, 103, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080411, 104, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080404, 105, 
    104);
Insert into FAKRU_TEST
   (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, METRIC, WEEK_NUM, MAP_POSN_NBR, CNT)
 Values
   ('0', '1000610', '001', 'TT', 
    'R', '000000000', '000000000000000000', 20080328, 106, 
    104);
COMMIT;


MY Query:

/* Formatted on 4/10/2013 9:29:59 AM (QP5 v5.139.911.3011) */
    SELECT COL_1,
           COL_2,
           COL_3,
           COL_4,
           COL_5,
           COL_6,
           --REPLACE(RTRIM(XMLAGG(XMLELEMENT(A,MET||'|')).EXTRACT('//text()')),'|','') XYZ
           RTRIM (XMLAGG (XMLELEMENT (A, METRIC || '|')).EXTRACT ('//text( )')) AS
              XYZ
      FROM (    SELECT * FROM FAKRU_TEST) A
--        WHERE
--                MAP_POSN_NBR=106
START WITH MAP_POSN_NBR = 1
CONNECT BY     PRIOR MAP_POSN_NBR + 1 = MAP_POSN_NBR
           AND PRIOR COL_1 = COL_1
           AND PRIOR COL_2 = COL_2
           AND PRIOR COL_3 = COL_3
           AND PRIOR COL_4 = COL_4
           AND PRIOR COL_5 = COL_5
           AND PRIOR COL_6 = COL_6
  GROUP BY COL_1,
           COL_2,
           COL_3,
           COL_4,
           COL_5,
           COL_6
		   
		   
ACTUAL RESULT:
0	1000610	001	TT	R	000000000	000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000001|000000000000000001|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|

EXPECTED RESULT:		   
0	1000610	001	TT	R	000000000	000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000001|000000000000000001|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|000000000000000000|

If you see the data for map_posn_nbr 7 and 8 only I have the metric value other than “000000000000000000”