Oracle AND & OR Operator

The Oracle allows you to use AND & OR operator combined to display the records from the table. While combine these operator, you must be aware how to use round brackets precision to evaluate each condition.

Oracle AND & OR Operator Syntax

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

Syntax

SELECT col1, col2, ...
FROM tablename
WHERE condition1 AND 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 with OR or both condition must be true with AND.

Oracle AND & OR OPERATOR example

The following Oracle statement is used to combined a record if any of the conditions separated by OR is TRUE or both of the conditions separated by AND is TRUE:

Example

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

Note:

In the above example, we are showing how to use the OR operator to combined records based on any of the conditions separated by OR is TRUE or both of the condition separated by AND is TRUE in SELECT statement.

« Previous