| Oracle PL/SQL Tutorial » Introduction » Comparison Operators |
| 1. 3. 1. Using Comparison Operators | ||||||||||||||||||
There are many comparison operators that you can use in a WHERE clause: | ||||||||||||||||||
The following table lists the comparison operators. | ||||||||||||||||||
|
| 1. 3. Comparison Operators | ||||
| 1. 3. 1. | Using Comparison Operators | |||
| 1. 3. 2. | Uses the not equal (<>) operator in the WHERE clause | |||
| 1. 3. 3. | Using the > operator | |||
| 1. 3. 4. | Use >= operator (2) | |||
| 1. 3. 5. | Use <= operator | |||
| 1. 3. 6. | Larger and equals | |||
| 1. 3. 7. | Less and equals | |||
| 1. 3. 8. | invalid relational operator | |||
