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