| 23. 1. 9. The Relational Operators: =, <>, !=, ~=, <, >, <=, >= |
|
|
String comparisons are case-sensitive. |
String comparisons are dependent on the character set being used. |
String comparisons are affected by the underlying datatype. |
Comparing two values as CHAR strings might yield different results than the same values compared as VARCHAR2 strings. |
It's important to remember that Oracle dates contain a time component |
| True Expressions | False Expressions | | 5 = 5 | 5 = 3 | | 'AAAA' = 'AAAA' | 'AAAA ' = 'AAAA' | | 5 != 3 | 5 <> 5 | | 'AAAA ' ~= 'AAAA' | 'AAAA' ~= 'AAAA' | | 10 < 200 | 10.1 < 10.05 | | 'Jeff' < 'Jenny' | 'jeff' < 'Jeff' | | TO_DATE('15-Nov-61' < '15-Nov-97') | TO_DATE('1-Jan-97' < '1-Jan-96') | | 10.1 <= 10.1 | 10 <= 20 | | 'A' <= 'B' | 'B' <= 'A' | | TO_DATE('1-Jan-97') <= TO_DATE('1-Jan-97) | TO_DATE('15-Nov-61') <= TO_DATE('15-Nov-60) |
|