In Oracle, the OR operator is used to check more than one condition and returns the result when any one of the given condition is true.
WHERE condition1 OR condition2 ... OR condition_n;
condition1, condition2, condition_n : returns the record if any one condition is true.
Select *from table1 where name like 's%' or age > 20
select *from table2 where salary<20000 or salary>25000