SELECT li.* FROM f1_fact f,
XMLTable('/factDataArea/mapping' PASSING xmltype(f.FACT_DATA_AREA) COLUMNS
seq NUMBER(10) PATH '/mapping/seq',
lowALFPer VARCHAR2(12) PATH '/mapping/lowALFPercent',
highALFper VARCHAR2(12) PATH '/mapping/highALFPercent',
lowALFKW VARCHAR2(12) PATH '/mapping/lowALFKW',
highALFKW VARCHAR2(12) PATH '/mapping/highALFKW',
newRateCCD VARCHAR2(12) PATH '/mapping/newRateClassCode'
) li;