Purpose
This function converts all English letters in a string to uppercase.
Syntax
NLS_UPPER(char [, 'nlsparam' ])
Parameters
Parameter |
Description |
|---|---|
| char | The string to be converted. The data type can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB. |
| nlsparam | The collation of the returned string. This parameter is optional. Note OceanBase Database does not support this parameter in the current version. |
Return type
The same data type as char.
Examples
Convert the string OceanBase to uppercase.
obclient> SELECT NLS_UPPER('OceanBase') "UPPER" FROM DUAL;
+-----------+
| UPPER |
+-----------+
| OCEANBASE |
+-----------+
1 row in set