How to convert characters to uppercase in Oracle

In Oracle, you can use the upper() function to convert characters to uppercase. The function of this function is to convert all the letters contained in the specified field in the specified table to uppercase. This function can be used with the select statement to perform the conversion. , the syntax is "select upper(specified field name) from specified table name".

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

How to convert characters to uppercase in oracle

upper: Function to convert lowercase characters to uppercase

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

select upper(user_name) from user

Examples are as follows:

Expand knowledge:

lower: Convert uppercase characters to lowercase The function

–converts 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 How to convert characters to uppercase in Oracle. For more information, please follow other related articles on the PHP Chinese website!