The ucase function turns all characters in a string to uppercase.
The syntax for the ucase function is:
ucase (string1)
string1 is the string that is going to be made upper case.
For example:
Select ucase(“alphabet”) from dual
would return “ALPHABET”
Ucase – Access Function