Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Operators

 

Comparison Operators

Comparison operators are used to compare one value or expression to another. All comparison operators return a boolean result. OperatorExampleUsage =IF A = B THENThe equality operator. IF A B THENThe inequality operator. !=IF A != B THENAnother inequality operator, synonymous with . ~=IF A ~= B THENAnother inequality operator, synonymous with . IF A The less than operator. IF A B THENThe greater than operator. IF A The less than or equal to operator. =IF A = B THENThe greater than or equal to operator. LIKEIF A LIKE B THENThe pattern-matching operator. BETWEENIF A BETWEEN B AND C THENChecks to see if a value lies within a specified range of values. INIF A IN (B,C,D) THENChecks to see if a value lies within a specified list of values. IS NULLIF A IS NULL THENChecks to see if a value is null.