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.

« Previous