Table of ContentsPreviousNext

Ispirer
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.


Table of ContentsPreviousNext
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.