Convert all the characters of the string to the upper case

By Santhosh N

This explains how to convert all the characters to the upper case alphabets

Oracle has a function by the name, UPPER used to convert the string characters to the upper case alphabets.

Syntax: UPPER(str)

Ex1: UPPER(‘egg’)
This returns ‘EGG as the result.

Ex2: LOWER(‘EggHead’)
This returns ‘EGGHEAD’ as the result

Note: While comparing the values from other source with the values in the columns using LIKE, UPPER can be used to compare irrespective of the case sensitivity.

Related FAQs

This explains how to convert all the characters to the lower case alphabets
This explains how to find the length of the string in oracle
This explains how to convert first character of the word to the upper case and rest to the lower case.
This explains how to get the character of the desired Ascii code in oracle.
This explains how to convert any character set strings to ascii character set strings in oracle.
This explains how to get the ascii code of the desired character in oracle.
Convert all the characters of the string to the upper case  (1581 Views)