Oracle AND

The Oracle AND operator returns TRUE if both component conditions are TRUE. Returns FALSE if either is FALSE;

Oracle AND example

Select *
From tutorials
Where author = 'STEVE'
AND title Like '%SQL%'
 
Select *
From books
Where price >= 10 And price <= 70;
 
Select *
From cities
Where country_id >= 10 And city_name Like '_M';