Home  >  Article  >  Database  >  How to convert case in oracle

How to convert case in oracle

WBOY
WBOYOriginal
2022-01-05 15:17:3116592browse

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

How to convert case in oracle

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:

How to convert case 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

Example As follows:

How to convert case in oracle

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn