Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to execute below query in tdbinput (Oracle) :
"
select extractValue(fc.data_xml,'/ns0:Customer/name ','xmlns:ns0="www.w3org.com/DataModel/Object/Customer"') name from customer fc
";
But its failing with syntax error because of "" and ' tokens . How to execute this query in tdbinput
Error is resolved using escape sequence \ before " . But its not fetching data ,even when data is present in that field.