oldy-vietnam
New Member
\[code\] <wbi:appData> <wbi:content wbi:name="1st_status"> <wbi:value xsi:type="xsd:string">Success</wbi:value> </wbi:content></wbi:appData>\[/code\]this xml is in a table which has a column in the form of CLOB type.I wanted to find if "wbi:value" tag exists in this xml or not ?I tried using existsnode but in sql developer it is saying an error as to declare existsnode.