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

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

Parameters

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

Table:

ORACLE AND & OR

Example 1

select id, name, age from table1 where id>2 AND age<28 OR age>25

ORACLE AND & OR
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +