Orcale SQL Tutorial

And

ORACLE AND

In Oracle, AND is used in select, insert, delete or update statement for checking two or more conditions.

Syntax

Where condition 1
AND condition 2
.
.
.
.
AND condition n

Parameters

condition 1, condition 2,......, condition n: condition to match the records.

Table:

ORACLE AND

Example 1

select id, name from table1 where name='dolly' AND age=18

ORACLE AND

Example 2

select id, name from table1 where name='shristee' AND id=1

ORACLE AND