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

snippet
WHERE conditions;

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
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents