If you need to check an input string for one or many strings and not worry about case sensitivity, REGEXP_CONTAINS is a very easy method to do so. You can define a list of strings to search for by separating by | as in the example.