Comparison operators
In Oracle, Comparison operators are used with the where clause. The following are the operators that can be used:-
| Comparison operator | Description |
|---|---|
| = | Equal |
| <> | Not Equal |
| != | Not equal |
| > | Greater than |
| >= | Greater than or equal |
| < | Less than |
| <= | Less than or equal |
Table:
Example: Equal operator
In Oracle, equal (=) operator is used for checking equality.
Query: select * from table1 where age = 26
Example: Not Equal operator
In Oracle, not equal operator is used for checking inequality. != or <> can be used for checking inequality in a query.
Query: select * from table1 where age <> 26
Query: select * from table1 where age != 26
Example: Greater than operator
In Oracle, greater than (>) operator is used for getting greater than value of the given expression.
Query: select * from table1 where age > 26
Example: Greater than or equal operator
In Oracle, greater than or equal (>=) operator is used for getting greater than or equal to value of the given expression.
Query: select * from table1 where age > = 26
Example: Less than operator
In Oracle, less than (<) operator is used for getting less than value of the given expression.
Query: select * from table1 where age < 26
Example: Less than or equal operator
In Oracle, less than or equal (<=) operator is used for getting less than or equal to value of the given expression.
Query: select * from table1 where age <= 26
