Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to retrieve XML Instance type(Oracle ) in tdbinput

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

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Error is resolved using escape sequence \ before " . But its not fetching data ,even when data is present in that field.