ORACLE OR

In Oracle, the OR operator is used to check more than one condition and returns the result when any one of the given condition is true.

Syntax

snippet
WHERE condition1
OR condition2
...
OR condition_n;

Parameters

condition1, condition2, condition_n : returns the record if any one condition is true.

Example 1

Select *from table1 where name like 's%' or age > 20

ORACLE OR

Example 2

select *from table2 where salary<20000 or salary>25000

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