Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Oracle to MySQL Migration overview.

Ispirer SQLWays Database Migration Software

Returning String in Uppercase

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

TABLE 61. 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.