'Cannot extract text value in XML CLOB in a table in PL SQL [duplicate]
I have a form created in XML and following data is stored as XML_CLOB,
<entry-form caption="SECTION B SOCIAL AND ENVIRONMENTAL STATUS OF THE PROJECT" data-key="sec B" show-caption="true" is-listing-grid="true" alignment="left" shade="bold" is-underline="false" __id="230"/*>
<dropdown label="1. Current status/ stage of the project" data-key="Current status stage of the project" multiple="false" mandatory="false" is-online-field="0" online-field-text="No" __id="281">
<option value="0" text="Design" is-highlight="false" __id="282" />
<option value="1" text="Construction" is-highlight="false" __id="283" />
<option value="2" text="Commissioning" is-highlight="false" __id="325" />
<option value="3" text="Operating" is-highlight="false" __id="326" />
I need to extract text value of each option above (Example Text value of option "0" is "Design".
I'm using SQL Developer as a beginner and please help me build a syntax to extract the above.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|