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