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:
Example 1
select id, name from table1 where name=’dolly’ AND age=18
Example 2
select id, name from table1 where name=’shristee’ AND id=1
Leave a Reply