Forum Discussion

yes1819's avatar
yes1819
New Contributor III
5 years ago

Add 2 parameters in WHERE CLAUSE in Oracle Select

Hi, I’m trying to put 2 parameters in Where Clause in Oracle Select with “and” Below is my pipeline parameters. I put some values between ’ ’ (I don’t have to put it) Below is my pipeline ...
igormicev's avatar
igormicev
Contributor
5 years ago

Hi @yes1819

Now, I see you have two single quotes for $BEC_NAME and $PRODUCT_SEGMENT. If those variables already have single quotes, then you shouldn’t add single quotes in the where clause expression

"BEC_NAME = "+$BEC_NAME+" AND PRODUCT_SEGMENT = "+$PRODUCT_SEGMENT+" "

or try this with the expression toggle (= sign) of the where clause turned off:

BEC_NAME = $BEC_NAME AND PRODUCT_SEGMENT = $PRODUCT_SEGMENT

If you still have issues, then try using the “Oracle - Execute” snap. Give it an input/output View and write your own SELECT statement combined with the variables (dynamic expression - SQL statement)

/Igor