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