Orcale SQL Tutorial
Loading...
where clause
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
Table 2: employee2
Example 1
Select *from employee1 where city = 'raipur' |
Example 2
Select *from employee2 where name like 's%' |