Comparison Operator in Oracle is used to compare the data in terms of various Parameters based on equality, inequality, Greater than, Less than, etc. of the data.
To follow the list of the Comparison Operator in Oracle, refer to the below table:
COMPARISON OPERATOR | SYMBOL | DESCRIPTION |
---|---|---|
Equal to | = | This Compares the data in terms of Equality |
Less Than | < | Test if the number is less than another one. |
Greater Than | > | Test if the number is greater than another one. |
Less Than equal to | <= | Test if the number is less than or equal to another number |
Greater Than equal to | >= | Test if the number is greater than or equal to another number. |
Not equal to | <> | This compare the data in terms of inequality |
- Log in to post comments