Javatpoint Logo
Javatpoint Logo

ORACLE AND

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

Syntax

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
Next TopicAND & OR




Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA