Logical Operators : Operators « PL SQL Operators « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Operators
3. Operators

PL/SQL has three logical operators: AND, OR, and NOT.

The NOT operator is typically used to negate the result of a comparison expression.

The AND and OR operators are typically used to link together multiple comparisons.

The Syntax for the NOT Operator:

NOT boolean_expression

boolean_expression can be any expression resulting in a boolean, or true/false value.

The Syntax for the AND Operator:

boolean_expression AND boolean_expression

boolean_expression can be any expression resulting in a boolean, or true/false value.

The AND operator returns a value of true if both expressions each evaluate to true;

otherwise, a value of false is returned.

The Syntax for the OR Operator:

boolean_expression OR boolean_expression

boolean_expression can be any expression resulting in a boolean, or true/false, value.

The OR operator returns a value of true if any one of the expressions evaluates to true.

A value of false is returned only if both the expressions evaluate to false.