Mega Code Archive

 
Categories / Oracle PLSQL Tutorial / PL SQL Operators
 

Use of Comparison Operators with Strings

When using character strings in comparison expressions, the result depends on several things: Character set Datatype Case (upper versus lower) In the typical ASCII environment, all lowercase letters are actually greater than all uppercase letters, digits are less than all letters, and the other characters fall in various places depending on their corresponding ASCII codes.