Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Introduction

 

Using the Logical Operators

There are three logical operators that may be used in a WHERE clause. The logical operators allow you to limit rows based on logical conditions. The logical operators are listed in the following table: OperatorDescription 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