In Oracle, where clause is used to filter the result. Where clause can be used in INSERT, UPDATE, DELETE, and SELECT statements.
WHERE conditions;
Conditions: for getting specified records.
Select *from employee1 where city = 'raipur'
Select *from employee2 where name like 's%'
