[resolved] URGENT: please help How can I write a query with double quote?

One Star

[resolved] URGENT: please help How can I write a query with double quote?

Hi,
I had an OracleInput which I had the following query:
"SELECT "+context.oracle_Schema+".tablea"+".ID,
"+"REGEXP_SUBSTR(REGEXP_SUBSTR("+context.oracle_Schema+".tablea"+".linkdesc,'+',1,1),'+',1,2) linkdesc"
+"FROM "+context.oracle_Schema+".tablea"
I encountered the following errors:
Multiple markers at this line
- Syntax error on token ""+"", delete this token
- Syntax error on token ""+"", delete this token
- Syntax error, insert ";" to complete Statement
- Syntax error, insert ")" to complete MethodInvocation
- Syntax error, insert "AssignmentOperator Expression" to complete
Assignment
- Syntax error, insert ";" to complete Statement
- Syntax error, insert "AssignmentOperator Expression" to complete
Assignment
- Syntax error, insert ";" to complete Statement
- Syntax error on token ""+"", ) expected
- Syntax error on token ""+"", delete this token
I am wondering how can I have a query with double quotes?
Any help is really really appreciated!
Thanks in advance!

Accepted Solutions
Employee

Re: [resolved] URGENT: please help How can I write a query with double quote?

You have to escape the double quote in the SQL Query with \ (\")

All Replies
Employee

Re: [resolved] URGENT: please help How can I write a query with double quote?

You have to escape the double quote in the SQL Query with \ (\")

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download