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.

Syntax

WHERE conditions;  

Parameters

Conditions: for getting specified records.

Table 1: employee1

Table 2: employee2

Example 1

Select *from employee1 where city = ‘raipur’

Example 2

Select *from employee2 where name like ‘s%’