Database Software

Hi,

we are having an xml column as blob data type in a  table,we need to retrieve xml columns indivdually. xml column having children and sub children nodes,so please suggest the best method.below is the xml format

<xml-response>

<tracking-number> a123bcd

</tracking-number>

<cleartrade>

<action> Approve

</action>

<deny-codes> </deny-codes>

<deny-descriptions> </deny-descriptions>

<exception-descriptions> </exception-descriptions>

<filter-codes> </filter-codes>

<filter-descriptions> </filter-descriptions>

<full-name> SMITH

</full-name>

<product-date> 2017-08-01T1Z

</product-date>

<suppliertrade>

<action> Approve

</action>

<deny-codes> </deny-codes>

<deny-descriptions> </deny-descriptions>

<exception-descriptions> </exception-descriptions>

<filter-codes> </filter-codes>

<filter-descriptions> </filter-descriptions>

<cleartrade-reason-code-description />

<cleartrade-score />

<active-duty-status> 0

</active-duty-status>

<active-duty-error-message>

</active-duty-error-message>

<summarytrade>

<amount-loans-charged-off> 0

</amount-loans-charged-off>

<amount-loans-in-collections> 0

</amount-loans-in-collections>

<days-sinceinquiry> 32

</days-sinceinquiry>

<daysninety-days>

</daysninety-days>

<daysyear>

</daysyear>

<in-bank-account-watch />

<in-collections-watch />

<last-charge-off> 2017-04-07T15:3

</last-charge-off>

<last-collection> 2017-01-01T15:30

</last-collection>

<loans-charged-off> 0

</loans-charged-off>

<loans-in-collections> 0

</loans-in-collections>

<non-conformant-loans> 2

</non-conformant-loans>

<summary-matrixtrades type="array">

<summary-matrixtrade>

<number-closed-lines> 7

</number-closed-lines>

<number-current-lines> 8

</number-current-lines>

<number-open-lines> 1

</number-open-lines>

<number-past-due-lines> 0

</number-past-due-lines>

<total-open-balance> 200

</total-open-balance>

<total-past-due-amount> 0

</total-past-due-amount>

<tradeline-type> SPML

</tradeline-type>

<tradeline-type-description> </tradeline-type-description>

</summary-matrixtrade>

<summary-matrixtrade>

<number-closed-lines> 0

</number-closed-lines>

<number-current-lines> 1

</number-current-lines>

<number-open-lines> 1

</number-open-lines>

<number-past-due-lines> 0

</number-past-due-lines>

<total-open-balance> 200

</total-open-balance>

<total-past-due-amount> 0

</total-past-due-amount>

<tradeline-type> Temp Acc

<tradeline-type-description> </tradeline-type-description>

</summary-matrixtrade>

<summary-matrixtrade>

<number-closed-lines> 7

</number-closed-lines>

<number-current-lines> 9

</number-current-lines>

<number-open-lines> 2

</number-open-lines>

<number-past-due> 0

</number-past-due>

<totalbalance> 400

</total-open-balance>

<total-past-due-amount> 0

</total-past-due-amount>

<tradeline-type> Total

</tradeline-type>

<tradeline-type-description> </tradeline-type-description>

</summary-matrixtrade>

</summary-matrixtrades>

</summarytrade>

<tradeline-stabilities type="array">

<tradeline-stability>

<tradeline-type> Tradeline

</tradeline-type>

<with-trade-stabilities-type> SupplierTradeline

</with-trade-stabilities-type>

<ten-minutes> 0

</ten-minutes>

<twenty-minutes> 0

</twenty-minutes>

<thirty-minutes> 0

</thirty-minutes>

<one-hour> 0

</one-hour>

<twentyfour-hours> 0

</twentyfour-hours>

<seven> 0

</seven>

<thirty> 0

</thirty>

<ninety> 1

</ninety>

</tradeline-stability>

<tradeline-stability>

<tradeline-type> Temp Account Record

</tradeline-type>

<with-trade-stabilities-type> SupplierTradeline

</with-trade-stabilities-type>

<ten-minutes> 1

</ten-minutes>

<twenty-minutes> 1

</twenty-minutes>

<thirty-minutes> 1

</thirty-minutes>

<one-hour> 1

</one-hour>

<twentyfour-hours> 2

</twentyfour-hours>

<seven> 2

</seven>

<thirty> 2

</thirty>

<ninety> 2

</ninety>

</tradeline-stability>

<tradeline-stability>

<tradeline-type> Total

</tradeline-type>

<with-trade-stabilities-type>

SupplierTradeline

</with-trade-stabilities-type>

<ten-minutes> 1

</ten-minutes>

<twenty-minutes> 1

</twenty-minutes>

<thirty-minutes> 1

</thirty-minutes>

<one-hour> 1

</one-hour>

<twentyfour-hours> 2

</twentyfour-hours>

<seven> 2

</seven>

<thirty> 2

</thirty>

<ninety> 3

</ninety>

</tradeline-stability>

</tradeline-stabilities>

<tradetrades type="array">

<tradetrade>

<account-charged-off> false

</account-charged-off>

<account-in-collections> false

</account-in-collections>

<account-opened> 2016-01-10T12

</account-opened>

<account-status/>

<actual-payment> 100

</actual-payment>

<amount-mop>

</amount-mop>

<amount-past-due> 0

</amount-past-due>

<apr> 0.000

</apr>

<closed-date> 2016-03-30T15:30:00Z

</closed-date>

<compliance-condition-code/>

<count-one-cycle-past-due> 0

</count-one-cycle-past-due>

<count-three-cycles-past-due> 0

</count-three-cycles-past-due>

<count-two-cycles-past-due> 0

</count-two-cycles-past-due>

<credit-limit> 200

</credit-limit>

<current-balance> 0

</current-balance>

<cycles-summarized> 0

</cycles-summarized>

<delinquency-date> </delinquency-date>

<ecoa-code> 1

</ecoa-code>

<highest-credit> 200

</highest-credit>

<interest-type-indicator> </interest-type-indicator>

<lender-name> 0101-020341-01342

</lender-name>

<loan-type> Internet 

</loan-type>

<mop> P@

</mop>

<mortgage-type/>

<non-conformant/>

<payment-history-profile> 00000-------------------

</payment-history-profile>

<portfolio-type> N

</portfolio-type>

<scheduled-payment> 0

</scheduled-payment>

<special-comment/>

<terms> 14-B-0

</terms>

<terms-duration> 14

</terms-duration>

<terms-frequency> B

</terms-frequency>

<tradeline-type> C6

</tradeline-type>

<verified> 2016-03-30T15

</verified>

<verified-date-indicator/>

<consumer-account-number> 12345

</consumer-account-number>

</tradetrade>

</tradetrades>

<trade-tars type="array">

<trade-tar>

<account-opened> 2016-03-30

</account-opened>

<current-balance> 400

</current-balance>

<consumer-account-number> 12345

</consumer-account-number>

<lender-name> 0101-0201-0301

</lender-name>

<loan-type> Internet Loan

</loan-type>

<portfolio-type> N

</portfolio-type>

<terms> 14-B-0

</terms>

<tradeline-type> C6

</tradeline-type>

<with-trade-tars-type> SupplierTradeline

</with-trade-tars-type>

</trade-tar>

</trade-tars>

<inquirytrades type="array">

<inquirytrade>

<inquiry-purpose-type> AR

</inquiry-purpose-type>

<inquiry-received-at> 2017-03-30T15

</inquiry-received-at>

<inquirytrade-type> C1

</inquirytrade-type>

<lender-name> 0101-0201-0301

</lender-name>

<location-phone> 81314815119

</location-phone>

</inquirytrade>

</inquirytrades>

</suppliertrade>

<inquiry-clustertrade>

<action> Approve

</action>

<deny-codes> </deny-codes>

<deny-descriptions> </deny-descriptions>

<exception-descriptions> </exception-descriptions>

<filter-codes> </filter-codes>

<filter-descriptions> </filter-descriptions>

<current-inquiry-cluster-position> 1

</current-inquiry-cluster-position>

<total-inquiriestrade>

<one-hour> 0

</one-hour>

<one-year> 5

</one-year>

<seven> 2

</seven>

<ten-minutes> 0

</ten-minutes>

<thirty> 2

</thirty>

<thirty-minutes> 0

</thirty-minutes>

<twenty-minutes> 0

</twenty-minutes>

<twentyfour-hours> 1

</twentyfour-hours>

<two-years> 5

</two-years>

</total-inquiriestrade>

<total-inquiry-clusterstrade>

<one-year> 5

</one-year>

<seven> 2

</seven>

<thirty> 2

</thirty>

<twentyfour-hours> 1

</twentyfour-hours>

<two-years> 5

</two-years>

</total-inquiry-clusterstrade>

</inquiry-clustertrade>

</cleartrade>

</xml-response>

below format is required