Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle OR Operator

The Oracle OR condition is used to test multiple conditions where records are returned when any one of the conditions are TRUE. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement. In other hand, Oracle OR operator is filter record if any of the conditions separated by OR is TRUE.

Oracle OR OPERATOR Syntax

To filter a record if any of the conditions separated by OR is TRUE, use the following syntax:

Syntax

SELECT col1, col2, ...
FROM tablename
WHERE condition1 OR condition2 OR condition3 ...;  

Parameters:

tablename: The table name from which you want to fetch the records.

condition: To specifies multiple conditions, either of the condition must be true to select records.

Oracle OR OPERATOR example

The following Oracle statement is used to filter a record if any of the conditions separated by OR is TRUE:

Example

SELECT firstName, lastName, address 
FROM tblCustomerLoan 
WHERE cellNo = 7897897890 OR lastName = 'Singh';

Note:

In the above example, we are showing how to use the OR operator to filter records based on any of the conditions separated by OR is TRUE SELECT statement.