Use of Comparison Operators with Strings : Operators « PL SQL Operators « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Operators
  3. Operators

When using character strings in comparison expressions, the result depends on several things:

  1. Character set
  2. Datatype
  3. Case (upper versus lower)

In the typical ASCII environment,

  1. all lowercase letters are actually greater than all uppercase letters,
  2. digits are less than all letters, and
  3. the other characters fall in various places depending on their corresponding ASCII codes.








23.1.Operators
23.1.1.Operators
23.1.2.The basic arithmetic operators in action
23.1.3.Logical Operators in PL/SQL
23.1.4.Running Anonymous Blocks of Code
23.1.5.Arithmetic Operators
23.1.6.Exponentiation
23.1.7.The negation and identity operators in action.
23.1.8.Comparison Operators
23.1.9.The Relational Operators: =, <>, !=, ~=, <, >, <=, >=
23.1.10.Logical Operators
23.1.11.String Operators
23.1.12.Use of Comparison Operators with Strings