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.
Copyright 1999-2023 Ispirer Systems. Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies. All rights reserved.