UPPER: Useful function in SQL to Convert to Upper-case

UCASE or UPPER takes a character expression as a parameter and returns a string in which all alpha characters have been converted to uppercase. The syntax for UPPER case function as given in Oracle documents is as follows.

Syntax for Upper Function

UCASE or UPPER ( Character Expression )

If the parameter type is CHAR , the return type is CHAR. Otherwise, the return type is VARCHAR.

Note: UPPER and LOWER follow the database locale.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.

Related Posts

Get new content delivered directly to your inbox.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.