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.



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#

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA