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:

Oracle Comparison operators

Example: Equal operator

In Oracle, equal (=) operator is used for checking equality.

Query: select * from table1 where age = 26

Oracle Comparison operators

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

Oracle Comparison operators

Query: select * from table1 where age != 26

Oracle Comparison operators

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

Oracle Comparison operators

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

Oracle Comparison operators

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

Oracle Comparison operators

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

Oracle Comparison operators
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents