\[code\]<wbi:appData> <wbi:content wbi:name="1st_status"> <wbi:value xsi:type="xsd:string">Success</wbi:value> </wbi:content> </wbi:appData></wbi:event>\[/code\]I need to get the value "1st_status" which is in 2nd line and "Success" which is in 3rd line using SQL developer.this xml is in a table which has a column in the form of CLOB type.
Read xml tag value from oracle using sql developer
- Thread starter tempo
- Start date