Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Operators

 

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 ExpressionsFalse Expressions 5 = 55 = 3 'AAAA' = 'AAAA''AAAA ' = 'AAAA' 5 != 35 5 'AAAA ' ~= 'AAAA''AAAA' ~= 'AAAA' 10 10.1 'Jeff' 'jeff' TO_DATE('15-Nov-61' TO_DATE('1-Jan-97' 10.1 10 'A' 'B' TO_DATE('1-Jan-97') TO_DATE('15-Nov-61')