Comparison operators

In Oracle, Comparison operators are used with the where clause. The following are the operators that can be used:-

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