Wednesday, April 21, 2010

Character Set in Oracle PL/SQL

 The PL/SQL character set includes

the upper- and lower-case letters A .. Z and a .. z

the numerals 0 .. 9

the symbols ( ) + - * / < > = ! ~ ^ ; : . ' @ % , " # $ & _
{ } ? [ ]

tabs, spaces, and carriage returns

PL/SQL is not case sensitive, so lower-case letters are equivalent to corresponding upper-case letters except within string and character literals.