Oracle Tutorial

OR Examples

Example 1

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

Example 2

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



Example 3

Select *
From books
Where price >= 1000 OR price >= 700;

Example 4

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