This content has been marked as final. Show 3 replies
SELECT * FROM your_table t WHERE XMLExists( '/Project/Basics[Attribute=$str]' PASSING t.xmltype_col , 'sam' as "str" ) ;
This is correct Only..But sometimes it returns Null even the search patern exists.Is there anything to do from schema side??
It might b some other issue.
This is correct Only..But sometimes it returns Null even the search patern exists.Could you give a sample for such a case?