PL SQL Operators Oracle PLSQL Tutorial

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.