Oracle - SQL - AND / OR

SELECT column_name(s)
FROM TABLE_NAME
WHERE condition
AND|OR condition