Javatpoint Logo
Javatpoint Logo

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

Parameters

Conditions: for getting specified records.

Table 1: employee1

ORACLE where clause

Table 2: employee2

ORACLE where clause

Example 1

Select *from employee1 where city = 'raipur'

ORACLE where clause

Example 2

Select *from employee2 where name like 's%'

ORACLE where clause
Next Topic#




Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA