How do I write a query for a Oracle database when I have several "like" values for the same column (in my example data "name")?
My example data for table "address":
name like "John" name like "Jon%" name like "Jonathan" name like "Frank"
Is there something like
LIKE in Oracle or do I have to write it for each value