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

Put this in your Where clause and try:

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

/Igor