Using like queries in query template with dynamic search values
Following is my query syntax to search the items in Oracle data base
select * from xyz where material like '%' || search value|| '%'.
But I am not able to write the search query in query template using [Param.1] to dynamically pass the search value.
I have tried the following syntax which is throwing execptions.
select * from xyz where material like '%' & [Param.1] & '%'.
Any help in this regard is very much appreciated.