Comparison Operators in Oracle SQL

Topic Introduction: Comparison Operators in Oracle SQL are =, >,>=,<,<=, <>/!=/^=, Between, IN, LIKE, IS NULL, IS NOT NULL, etc. Comparison operators are used in conditions that compare one expression with another value or expression. They are used in the WHERE clause. 

Syntax

WHERE expression operator value

Example

select last_name,hire_date,salary

from employees

where salary>=10000;

In this example, we want to retrieve employees' Last_name, Hire_date, and salary who get a salary of 10000 or more then.

Note 1. an alias cannot be used in the WHERE clause.

2. If characters or dates are used in the condition values, they must be enclosed with single quotation marks ('').