Returning String in Uppercase

This subsection describes functions which return string in uppercase in various databases and thier conversion by SQLWays.

TABLE 50. Returning string in uppercase

Database	Syntax	Description
Oracle	UPPER (exp)	Returns expression (exp) with all letters uppercase. exp - can be constant or variable containing constant of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB data type. Return type: the same as the data type of exp.
MySQL	UPPER (exp) UCASE (exp)	Returns expression (exp) with all letters uppercase. exp - can be constant or variable containing constant. Return type: the same as the data type of exp.