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.
This subsection describes functions which return string in uppercase in various databases and thier conversion by SQLWays.
UPPER (exp)
UPPER (exp) UCASE (exp)
