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

Highlighted
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 \ (\")

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.