<DPD>000</DPD>
  <DT>03-11</DT>
  <DPD>000</DPD>
  <DT>02-11</DT>
  <DPD>XXX</DPD>
  <DT>01-11</DT>
  <DPD>XXX</DPD>
  <DT>12-10</DT>
  <DPD>000</DPD>
  <DT>11-10</DT>
  <DPD>000</DPD>
  <DT>10-10</DT>
  <DPD>000</DPD>
  <DT>09-10</DT>
  <DPD>000</DPD>
  <DT>08-10</DT>
  <DPD>XXX</DPD>
  <DT>07-10</DT>
  <DPD>000</DPD>
  <DT>06-10</DT>

select extractvalue(column_value, '//DPD[1]') DPD,
       extractvalue(column_value, '//DT[1]')DT
  from rlos_binary_cibil,
       table(xmlsequence(xmltype(ded_enq_xml).extract('/CIRS/CIR/TL/PAYMENT_HISTORY'))),
 where sno = '111111';