Skip to main content

I have the below line in SQL query where the user could write only one company or % for all. Is there a way to enable multiple values like we normally do in any view filter by ;?  I need this to be a parameter variable based on the user input and not fixed in the query itself.

 

COMPANY LIKE NVL('&COMPANY', '%')

 

regards

Housseiny

Be the first to reply!

Reply