I have a table:\[code\]create table app_instr(deal NUUMBERXML_DATA SYS.XMLTYPE);\[/code\]and have following 2 rows in XML_DATA column:\[code\]<INSTR><EXTREFERENCE xmlns:xs="http://www.w3.org/2001/XMLSchema-instance"> <REFERENCE REFSYSTEM="SYSTEM1" AUTOCAPTURED="false" READONLY="false">42852 </REFERENCE></EXTREFERENCE></INSTR><INSTR><EXTREFERENCE xmlns:xs="http://www.w3.org/2001/XMLSchema-instance"> <REFERENCE REFSYSTEM="SYSTEM2" AUTOCAPTURED="false" READONLY="false">42852 </REFERENCE></EXTREFERENCE></INSTR>\[/code\]My requirement is to extract int value 42852 only if REFERENCE REFSYSTEM="SYSTEM1". Can you please help me what oracle function to use for this?
Oracle function to searching in XML tag
- Thread starter shaqa
- Start date