Using the Logical Operators : Logical Operators « Introduction « Oracle PL/SQL Tutorial

  1. There are three logical operators that may be used in a WHERE clause.
  2. The logical operators allow you to limit rows based on logical conditions.
  3. The logical operators are listed in the following table:
x AND yReturns true when both x and y are true
x OR yReturns true when either x or y is true
NOT xReturns true if x is false, and returns false if x is true

1.4.Logical Operators
1.4.1.Using the Logical Operators
1.4.2.Use the AND operator to retrieve rows
1.4.3.Use the OR operator to retrieve rows
1.4.4.Use NOT in where clause
1.4.5.Understanding Operator Precedence