Extract values from XML string using oracle xml commands

Question

I want to extract the values of the attributes active_ind and call_status from the following string:

<INSURANCE_HISTORY active_ind="Y" call_status="A"/>

I have sorted this issue with substring and instr, but need to use XML commands to extract these values.

Arkadiusz Łukasiewicz · Accepted Answer · 2016-05-25 06:59:10Z

1

Xpath, xquery, i recommend you to read something about these technology. @ is used to access attribute in xml elment

select extract(xmltype('<INSURANCE_HISTORY active_ind="Y" call_status="A"/>'),'/INSURANCE_HISTORY/@active_ind')  active_ind
, extract(xmltype('<INSURANCE_HISTORY active_ind="Y" call_status="A"/>'),'/INSURANCE_HISTORY/@call_status') call_status

 from dual;

answered May 25, 2016 at 6:59

Arkadiusz Łukasiewicz

6,3761 gold badge13 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract values from XML string using oracle xml commands

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related