How to convert case in oracle

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!