What is the function to convert to uppercase in Oracle?

The function to convert to uppercase in Oracle is upper; this function is used to convert all letters in the specified string to uppercase. The returned value is the same as the data type of char. The database is defined according to the basic character set. Binary mapping to set the case of characters, the syntax is "upper(string)".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the function that converts to uppercase in oracle?

The function that converts to uppercase in oracle is the upper function

The UPPER function is used to convert the specified string into All letters of are converted to uppercase. If the characters in the string are not letters, they are not affected by this function.

The char to be converted can be any data type, such as CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB. The value returned by the UPPER function is the same data type as char. The database sets character case according to the binary mapping defined for the underlying character set.

Usage:

UPPER( string )

Parameters used:

string-used to specify the string that needs to be converted.

Return value:

The UPPER function in PLSQL returns a string value.

The example is as follows:

Pass a string as a parameter, with the first character in uppercase and the remaining characters in lowercase.

Output results:

GEEKSFORGEEKS

Extended knowledge:

lower: uppercase characters Convert to lowercase function

– Convert all letters containing letters in the user_name field information in the user table to lowercase

select lower(user_name) from user

The example is as follows:

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of What is the function to convert to uppercase in Oracle?. For more information, please follow other related articles on the PHP Chinese website!