ORACLE OR

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.

Syntax

Parameters

condition1, condition2, condition_n : returns the record if any one condition is true.

Example 1

Select *from table1 where name like 's%' or age > 20

Example 2

select *from table2 where salary<20000 or salary>25000