Oracle UPPER Function Explained

1 year ago
Isabella Edwards
1 minute

In Oracle database, the UPPER function is used to convert a string to uppercase. The syntax is as follows:

UPPER(string)

One of the strings that needs to be converted to uppercase is “string”. For example:

SELECT UPPER('Hello, World!') FROM dual;

-- 结果为：HELLO, WORLD!

The UPPER function is very useful in cases where case sensitivity is important, as it ensures that comparing strings will not result in errors due to differences in capitalization.

bannerAds