UPPER Function in Oracle SQL – PLSQL

The UPPER Function in Oracle SQL / PLSQL is used to convert the letters of a string to upper case

Syntax for the using the UPPER Function in Oracle SQL / PLSQL is:

SELECT UPPER(string)
FROM table_name;

string is the string whose letters will be converted to UPPER case.

Examples:

Using UPPER Function in Oracle SQL / PLSQL SELECT statement:

SELECT UPPER('Tech Honey')
FROM dual;

Will return ‘TECH HONEY’

SELECT UPPER('tech honey')
FROM dual;

Will return ‘TECH HONEY’

SELECT
UPPER('TECh HOney')
FROM dual;

Will return ‘TECH HONEY’


Tagged , , , , , , , , , , , . Bookmark the permalink.