Posted on Thursday, 6th August 2009 by captainmi2

The upper function in Oracle PL\SQL converts all letters in the specified string to uppercase. If there are characters in the string that are not letters, they are unaffected by this function.
The syntax for the upper function is:
upper(str)
str is the string to convert to uppercase.
see example below.

SQL> select upper(’abcd2efgh3′) col1 from dual;
COL1
———-
ABCD2EFGH3
SQL>

Tags:
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)