Oracle OR

The Oracle OR statement returns TRUE if either component condition is TRUE. Returns FALSE if both are FALSE.

Oracle OR example

Select *
From users u 
Where u.name = 'ANIA' 
OR u.name = 'PARKER';

Select *
From tutorials
Where author = 'TOM'
OR title Like '%ORACLE%'

Select *
From books
Where price >= 100 OR price >= 70;

Select *
From cities
Where country_id >= 10 OR city_name Like '_M';