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
WHERE condition1
OR condition2
...
OR condition_n; 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
Leave a Reply