Orcale SQL Tutorial
Loading...
And & Or
ORACLE AND & OR
In Oracle, AND & OR can be combined and 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:
Example 1
select id, name, age from table1 where id>2 AND age<28 OR age>25 |