In Oracle, AND is used in select, insert, delete or update statement for checking two or more conditions.
Where condition 1 AND condition 2 . . . . AND condition n
condition 1, condition 2,......, condition n: condition to match the records.
select id, name from table1 where name='dolly' AND age=18
select id, name from table1 where name='shristee' AND id=1
