Oracle PL/SQL Upper Function

The Upper function converts all letters in the specified string to uppercase.

The Upper Function syntax:

upper( string )

Example

select upper('Learn Oracle Lesson') from dual; 

LEARN ORACLE LESSON


select upper('oracle 10g') from dual;

ORACLE 10G