Multiple like conditions for same column? 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 IN() with LIKE in Oracle or do I have to write it for each value OR separated?
Using OR would be the way to go, yes.