Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to achieve a case conversion function in Oracle, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Oracle case conversion function

Lowercase to uppercase UPPer

Uppercase to lowercase LOWER

Example:

Select lower (ename) from emp; select upper (ename) from emp;-whether it contains the letters (uppercase and lowercase) select case when regexp_like ('123' else'). ([Amurz] + | [Amurz])') then 'contains the letter' else 'does not contain the letter' end from dual;-- whether it contains the lowercase letter select case when regexp_like ('Songlim' [aMuz]') then 'contains the lowercase letter' else 'does not contain the small letter' end from dual -- whether to include the uppercase letter select case when regexp_like ('line s line','[Amurz]') then 'contains the uppercase letter' else 'does not contain the capital letter' end from dual;'- whether it contains the lowercase letter select 'contains the lowercase' from dual where regexp_like'('Che Min' [Amurz]') The above is how to achieve a case conversion function in Oracle. Xiaobian believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.