|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)|