In Oracle, the UPPER() function returns its argument with all letters in uppercase.
string functions
NLS_INITCAP() Function in Oracle
In Oracle, the NLS_INITCAP() function returns its argument with the first letter of each word in uppercase, and all other letters in lowercase.
However, the actual capitalisation will depend on the collation being used. For example, it could result in more than the first letter being capitalised.
It’s similar to the INITCAP() function, except that it accepts a second argument that allows you to specify the collation. The collation handles special linguistic requirements for case conversions.
INITCAP() Function in Oracle
In Oracle, the INITCAP() function returns its argument with the first letter of each word in uppercase, and all other letters in lowercase.
For special linguistic requirements for case conversions, you may want to try the NLS_INITCAP() function instead.
CHR() Function in Oracle
In Oracle, the CHR() function returns a character based on the code values provided as an argument.
More specifically, it returns the character having the binary equivalent to its argument as a VARCHAR2 value in either the database character set or, if you specify USING NCHAR_CS, the national character set.
TRIM() Function in Oracle
In Oracle, the TRIM() function allows you to trim characters from the sides of a string.
You can trim leading characters, trailing characters, or both.
By default, it trims white space, but you can optionally specify a different character or characters to trim.
LTRIM() Function in Oracle
In Oracle, the LTRIM() function allows you to trim the left part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
RTRIM() Function in Oracle
In Oracle, the RTRIM() function allows you to trim the right part of a string. By default, it trims white space, but you can optionally specify a different character or characters to trim.
Replace Multiple Characters in a String in SQL Server (T-SQL)
In SQL Server, the REPLACE() function enables us to replace a string with another string. But what if you want to replace a list of characters with another list of characters?
The TRANSLATE() function might help.
MariaDB LTRIM() vs LTRIM_ORACLE(): What’s the Difference?
MariaDB has an LTRIM() function and a LTRIM_ORACLE() function. Both functions do essentially the same thing. But there is a minor difference.