Pages

30 January, 2014

Create a SQL Table from XML content (CLOB) - Oracle DB

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;

No comments:

Post a Comment