Method: 1. Use the lower() function to convert uppercase characters to lowercase, the syntax is "select lower (specified character) from user"; 2. Use the upper() function to convert lowercase characters to uppercase, the syntax is It is "select upper(specified character) from user".
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
How does oracle convert uppercase to lowercase
lower: Function to convert uppercase characters to lowercase
–Convert the characters in the user table Convert all letters containing letters in the user_name field information to lowercase
select lower(user_name) from user
The example is as follows:
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
Example As follows:
Recommended tutorial: "Oracle Tutorial"
The above is the detailed content of How to convert case in oracle. For more information, please follow other related articles on the PHP Chinese website!