Javatpoint Logo
Javatpoint Logo

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
Next TopicDELETE




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA